{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["PAPARAN UTAMA","MUKA HADAPAN","PATA 3A(Premis)","LAMPIRAN 3A"," PATA 3B (Premis)","F6 6 (PENERIMAAN)","F7 2 (OPERASI)","F8 5 (NILAI)","F9 2 (PPUN)","F10 5(LUPUS) ","F11 5 (HAPUSKIRA)","PATA 3C (Premis)","LAMPIRAN 3C"],"not_rendered":{"charts":0,"images":90,"macros":1,"external_links":1,"defined_names":25,"comments":12,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PAPARAN UTAMA","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,1,1,3],[2,1,2,3]]}

{"sheet":"MUKA HADAPAN","index":1,"n_rows":74,"n_cols":21,"rows_kept":74,"cut":false,"hidden":false,"merged":[[17,4,17,6],[18,4,18,6],[52,0,52,6],[46,0,46,6],[47,0,47,6],[51,0,51,6],[35,0,35,6],[43,0,44,6],[41,0,41,6],[34,0,34,6],[19,4,20,6],[21,4,22,6],[23,4,24,6],[26,0,31,6]]}
[]
[]
[]
[]
[1,"SUKUAN",":","Sila Pilih"]
[2,"TAHUN\n*Contoh: 2023",":","Sila Kemaskini"]
[3,"KEMENTERIAN",":","Sila Pilih"]
[4,"NEGERI/ WILAYAH",":","Sila Pilih"]
[5,"DAERAH\n*Contoh: JOHOR BAHRU",":","Sila Kemaskini"]
[6,"JABATAN/AGENSI\n*Contoh: PDRM",":","Sila Kemaskini"]
[7,"NAMA PREMIS (sama seperti maklumat di pendaftaran)\n*Contoh: IBU PEJABAT POLIS DAERAH KLUANG JOHOR",":","Sila Kemaskini"]
[8,"NO. DPA (Sekiranya Ada)\n*Contoh: 1146110MYS.010340.BS0003",":","Sila Kemaskini"]
[9,"STATUS PEMILIKAN ASET",":","Sila Pilih"]
[10,"TARIKH LAPORAN DISEDIAKAN \n*Contoh: 01/02/2023",":","00:00:00"]
[11,"DISEDIAKAN OLEH\n*Contoh: EN ALI BIN ABU",":","Sila Kemaskini"]
[]
[]
[null,null,null,null,"MUKA HADAPAN"]
[null,null,null,null,{"$f":"D13","v":"Sila Pilih"}]
[null,null,null,null,"PERINGKAT PREMIS"]
[]
[null,null,null,null,"1 DPA"]
[]
[null,null,null,null,"VERSI PINDAAN: 02\nTarikh: 1/04/2024"]
[]
[]
["PELAPORAN PENGURUSAN ASET TAK ALIH DI BAWAH KAWALAN KEMENTERIAN/ JABATAN/ AGENSI BERDASARKAN TATACARA PENGURUSAN ASET TAK ALIH (TPATA) VERSI 2.0"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"*Ruangan ini ialah bagi tujuan LINK EXCEL (JANGAN DELETE)"]
[null,null,null,null,null,null,null,null,null,null,"*Link Drop Down JKR PATA 3A & coverpage",null,null,"*Link Drop Down Muka Hadapan",null,null,"*Link Drop Down Muka Hadapan",null,null,"*Link Drop Down Muka Hadapan"]
[{"$f":"D6","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,null,"-","Sila Pilih",null,"Sila Pilih",null,null,"NO","KEMENTERIAN",null,null,"Sila Pilih"]
[{"$f":"D5","v":"Sila Pilih"},null,null,null,null,null,null,null,null,null,"M","MILIKAN",null,"JAN - MAC  (Sehingga Sukuan 1 )",null,null,null,"Sila Pilih",null,1,"JOHOR"]
[null,null,null,null,null,null,null,null,null,null,"S","SEWA",null,"JAN - JUN   (Sehingga Sukuan 2 )",null,null,1,"AGC - JABATAN PEGUAM NEGARA",null,2,"KEDAH"]
[null,null,null,null,null,null,null,null,null,null,"T","TUMPANG",null,"JAN - SEPT  (Sehingga Sukuan 3 )",null,null,2,"ISTANA NEGARA",null,3,"KELANTAN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"JAN - DEC  (Sehingga Sukuan 4 )",null,null,3,"JAN - JABATAN AUDIT NEGARA",null,4,"MELAKA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"JPA - JABATAN PERKHIDMATAN AWAM",null,5,"NEGERI SEMBILAN"]
[null,null,null,null,null,null,null,null,null,null,"#A19D9D",null,null,null,null,null,5,"JPM - JABATAN PERDANA MENTERI",null,6,"PAHANG"]
["NAMA PREMIS",null,null,null,null,null,null,null,null,null,"*Link Drop Down JKR PATA 3B",null,null,null,null,null,6,"KBS - KEMENTERIAN BELIA DAN SUKAN",null,7,"PERAK"]
[null,null,null,null,null,null,null,null,null,null,"-","Sila Pilih",null,null,null,null,7,"KDN - KEMENTERIAN DALAM NEGERI",null,8,"PERLIS"]
[{"$f":"D11","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,null,"AB",null,null,null,null,null,8,"KKM - KEMENTERIAN KESIHATAN MALAYSIA",null,9,"TERENGGANU"]
[null,null,null,null,null,null,null,null,null,null,"AJ",null,null,null,null,null,9,"KEMENTERIAN KOMUNIKASI",null,10,"PULAU PINANG"]
[null,null,null,null,null,null,null,null,null,null,"AA",null,null,null,null,null,10,"KEMENTERIAN DIGITAL",null,11,"SABAH"]
["NO DPA (Sekiranya Ada)",null,null,null,null,null,null,null,null,null,"AP",null,null,null,null,null,11,"KE - KEMENTERIAN EKONOMI",null,12,"SARAWAK"]
[{"$f":"D12","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,null,"LL",null,null,null,null,null,12,"KKR - KEMENTERIAN KERJA RAYA",null,13,"SELANGOR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"KLN - KEMENTERIAN LUAR NEGERI",null,14,"WILAYAH PERSEKUTUAN KUALA LUMPUR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"KPDN - KEMENTERIAN PERDAGANGAN DALAM NEGERI DAN KOS SARA HIDUP",null,15,"WILAYAH PERSEKUTUAN LABUAN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"KPKT - KEMENTERIAN PERUMAHAN DAN KERAJAAN TEMPATAN",null,16,"WILAYAH PERSEKUTUAN PUTRAJAYA"]
[{"$f":"B13","v":"STATUS PEMILIKAN ASET"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"KPK - KEMENTERIAN PERLADANGAN DAN KOMODITI"]
[{"$f":"D13","v":"Sila Pilih"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"KPKM - KEMENTERIAN PERTANIAN DAN KETERJAMINAN MAKANAN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"KKDW - KEMENTERIAN KEMAJUAN DESA DAN WILAYAH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"KPM - KEMENTERIAN PENDIDIKAN MALAYSIA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"KPN - KEMENTERIAN PERPADUAN NEGARA",null,"*Link VLOOK UP 3A","Column1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"KPT - KEMENTERIAN PENDIDIKAN TINGGI",null,"MILIKAN","M"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"KPWKM - KEMENTERIAN PEMBANGUNAN WANITA, KELUARGA DAN MASYARAKAT",null,"SEWA","S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"KSM - KEMENTERIAN SUMBER MANUSIA",null,"TUMPANG","T"]
[null,"TARIKH LAPORAN DISEDIAKAN ",":",{"$f":"D14","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,24,"KUSKOP - KEMENTERIAN PEMBANGUNAN USAHAWAN DAN KOPERASI ",null,"Sila Pilih","-"]
[null,"DISEDIAKAN OLEH",":",{"$f":"D15","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,null,null,null,null,25,"MINDEF - KEMENTERIAN PERTAHANAN MALAYSIA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"MITI - KEMENTERIAN PELABURAN, PERDAGANGAN DAN INDUSTRI "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"MOF - KEMENTERIAN KEWANGAN MALAYSIA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"MOSTI - KEMENTERIAN SAINS, TEKNOLOGI DAN INOVASI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"MOT - KEMENTERIAN PENGANGKUTAN MALAYSIA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"MOTAC - KEMENTERIAN PELANCONGAN, SENI DAN BUDAYA MALAYSIA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,"NRES - KEMENTERIAN SUMBER ASLI DAN KELESTARIAN ALAM"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,"PETRA - KEMENTERIAN PERALIHAN TENAGA DAN TRANSFORMASI AIR "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,"PARLIMEN MALAYSIA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,"PEJABAT PENYIMPAN MOHOR BESAR RAJA-RAJA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,"SPA - SURUHANJAYA PERKHIDMATAN AWAM MALAYSIA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,"SPR - SURUHANJAYA PILIHAN RAYA MALAYSIA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"SPRM - SURUHANJAYA PENCEGAHAN RASUAH MALAYSIA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"SPP- SURUHANJAYA PERKHIDMATAN PENDIDIKAN (SPP)"]

{"sheet":"PATA 3A(Premis)","index":2,"n_rows":166,"n_cols":17,"rows_kept":166,"cut":false,"hidden":false,"merged":[[18,1,19,16],[11,8,11,11],[1,1,1,16],[12,2,13,4],[11,2,11,7],[2,1,2,15],[3,1,3,15],[12,5,12,9],[12,10,12,16],[13,5,13,7],[13,8,13,9],[13,10,13,13],[13,14,13,16],[12,1,13,1],[161,1,162,1],[161,2,162,4],[161,5,161,9],[161,10,161,16],[162,5,162,7],[162,8,162,9],[162,10,162,13],[162,14,162,16]]}
[]
[null,"JKR.PATA-3A"]
[null,"LAPORAN KESEDIAAN SUMBER PENGURUSAN ASET TAK ALIH"]
[null,"(Peringkat Premis)"]
[null,null,null,null,null,"Bulan :",{"$f":"'MUKA HADAPAN'!$D$5","v":"Sila Pilih"},null,null,null,"Tahun :",{"$f":"'MUKA HADAPAN'!$D$6","v":"Sila Kemaskini"}]
[]
[null,"Kementerian                               :",{"$f":"'MUKA HADAPAN'!$D$7","v":"Sila Pilih"},null,null,null,null,null,null,"Jabatan/ Agensi      :",null,{"$f":"'MUKA HADAPAN'!$D$10","v":"Sila Kemaskini"}]
[null,"Negeri/ Wilayah                          :",{"$f":"'MUKA HADAPAN'!$D$8","v":"Sila Pilih"},null,null,null,null,null,null,"Daerah                     :",null,{"$f":"'MUKA HADAPAN'!$D$9","v":"Sila Kemaskini"}]
[null,"Nama Premis                              :",{"$f":"'MUKA HADAPAN'!$D$11","v":"Sila Kemaskini"}]
[null,"No. DPA                                      :",{"$f":"'MUKA HADAPAN'!$D$12","v":"Sila Kemaskini"}]
[]
[null,null,null,null,null,null,null,null,"RUJUK LAMPIRAN 3A"]
[null,null,"1. Maklumat UPF",null,null,"2. Sumber Manusia",null,null,null,null,"3. Aktiviti Keperluan Pejabat Unit Pengurusan Fasiliti (UPF)"]
[null,null,null,null,null,"Staf UPF",null,null,"Kompetensi dan Latihan*",null,"Pengurusan Pejabat",null,null,null,"Peralatan Kerja"]
["Bil\n","Premis","Bilangan UPF Premis","Jenis pemilikan aset","Bilangan Premis Aset","Lulus (Bil.) \n(a)","Diisi (Bil.)  \n(b)","% Diisi \n(b/a)","% Staf UPF yang hadir latihan ","% Staf UPF yang mencapai tahap kompetensi 3 dan ke atas*\n","% Pematuhan ruang/ staf UPF mengikut EPU ","% Perabot asas setiap staf UPF","Mesin fotostat (Bil.)","Telefon dan alat komunikasi  (Bil.)","Komputer (Bil.)","Alat pemeriksaan dan pengujian (Bil.)","Kenderaan (Bil.)"]
[null,{"$f":"C9","v":"Sila Kemaskini"},0,{"$f":"VLOOKUP('MUKA HADAPAN'!$D13,T_Pemilikan[],2,FALSE)","v":"-"},0,0,0,{"$f":"IFERROR($G16/$F16,0%)","v":0},{"$f":"'LAMPIRAN 3A'!$J$36","v":0},{"$f":"'LAMPIRAN 3A'!$N$36","v":0},{"$f":"'LAMPIRAN 3A'!$T$36","v":0},{"$f":"'LAMPIRAN 3A'!$AB$36","v":0},0,0,0,0,0]
["1",{"$f":"Table3A_M_ST[Premis]","v":"Sila Kemaskini"},{"$f":"SUBTOTAL(109,Table3A_M_ST[Bilangan UPF Premis])","v":0},{"$f":"Table3A_M_ST[Jenis pemilikan aset]","v":"-"},{"$f":"SUBTOTAL(109,Table3A_M_ST[Bilangan Premis Aset])","v":0},{"$f":"SUBTOTAL(109,Table3A_M_ST[Lulus (Bil.) \n(a)])","v":0},{"$f":"SUBTOTAL(109,Table3A_M_ST[Diisi (Bil.)  \n(b)])","v":0},{"$f":"IFERROR(Table3A_M_ST[[#Totals],[Diisi (Bil.)  \n(b)]]/Table3A_M_ST[[#Totals],[Lulus (Bil.) \n(a)]],0%)","v":0},{"$f":"SUBTOTAL(101,Table3A_M_ST[% Staf UPF yang hadir latihan ])","v":0},{"$f":"SUBTOTAL(101,Table3A_M_ST[% Staf UPF yang mencapai tahap kompetensi 3 dan ke atas*\n])","v":0},{"$f":"SUBTOTAL(101,Table3A_M_ST[% Pematuhan ruang/ staf UPF mengikut EPU ])","v":0},{"$f":"SUBTOTAL(101,Table3A_M_ST[% Perabot asas setiap staf UPF])","v":0},{"$f":"SUBTOTAL(109,Table3A_M_ST[Mesin fotostat (Bil.)])","v":0},{"$f":"SUBTOTAL(109,Table3A_M_ST[Telefon dan alat komunikasi  (Bil.)])","v":0},{"$f":"SUBTOTAL(109,Table3A_M_ST[Komputer (Bil.)])","v":0},{"$f":"SUBTOTAL(109,Table3A_M_ST[Alat pemeriksaan dan pengujian (Bil.)])","v":0},{"$f":"SUBTOTAL(109,Table3A_M_ST[Kenderaan (Bil.)])","v":0}]
[]
[null,"Petunjuk: *0: Tiada kesedaran/kefahaman, 1: Ada kesedaran/kefahaman, 2: berkebolehan melaksana kerja dengan seliaan, 3: berkebolehan melaksana kerja tanpa seliaan, 4: berkebolehan merancang dan mengurus kerja, 5: amat berkebolehan merancang/mengurus & memimpin organisasi (kakitangan perlu memenuhi kompetensi tahap 3 dan ke atas)."]
[]
[]
[null,"Disediakan Oleh :",null,null,null,null,null,null,null,null,null,"Disahkan  Oleh :"]
[]
[]
[]
[null,"(cap nama & jawatan)",null,null,null,null,null,null,null,null,null,"(cap nama & jawatan)"]
[null,"Tarikh :",null,null,null,null,null,null,null,null,null,"Tarikh :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Disediakan oleh Urus Setia JPAK:"]
[null,"CONTOH PENGISIAN"]
[]
[null,null,"1. Maklumat UPF",null,null,"2. Sumber Manusia",null,null,null,null,"3. Aktiviti Keperluan Pejabat Unit Pengurusan Fasiliti (UPF)"]
[null,null,null,null,null,"Staf UPF",null,null,"Kompetensi dan Latihan*",null,"Pengurusan Pejabat",null,null,null,"Peralatan Kerja"]
["Bil\n","Premis","Bilangan UPF Premis","Jenis pemilikan aset","Bilangan Premis Aset","Lulus (Bil.) \n(a)","Diisi (Bil.)  \n(b)","% Diisi \n(b/a)","% Staf UPF yang hadir latihan ","% Staf UPF yang mencapai tahap kompetensi 3 dan ke atas*\n","% Pematuhan ruang/ staf UPF mengikut EPU ","% Perabot asas setiap staf UPF","Mesin fotostat (Bil.)","Telefon dan alat komunikasi  (Bil.)","Komputer (Bil.)","Alat pemeriksaan dan pengujian (Bil.)","Kenderaan (Bil.)"]
[null,"IBU PEJABAT POLIS DAERAH KLUANG JOHOR",1,"M",1,5,4,0.8,0.5,0.75,0.25,1,1,4,4,4,0]
["1","IBU PEJABAT POLIS DAERAH KLUANG JOHOR","1","M","1","5","4","80%","50%","75%","25%","100%","1","4","4","4","0"]

{"sheet":"LAMPIRAN 3A","index":3,"n_rows":203,"n_cols":44,"rows_kept":203,"cut":false,"hidden":false,"merged":[[34,2,34,4],[11,8,12,8],[11,7,12,7],[8,1,8,5],[11,5,12,5],[11,4,12,4],[11,3,12,3],[11,2,12,2],[11,1,12,1],[10,2,10,4],[35,2,35,4],[8,15,8,27],[9,21,9,27],[11,27,12,27],[11,15,12,15],[8,7,8,13],[9,15,9,19],[11,16,12,16],[11,17,12,17],[9,7,9,9],[9,11,9,13],[35,7,35,8],[11,13,12,13],[11,9,12,9],[34,7,34,8],[9,1,9,5],[184,36,184,37],[11,21,11,23],[11,19,12,19],[35,11,35,12],[34,11,34,12],[34,21,34,23],[35,21,35,23],[34,15,34,17],[35,15,35,17],[11,12,12,12],[11,11,12,11],[11,24,11,26],[11,18,12,18],[192,1,192,5],[192,7,192,13],[192,15,192,27],[193,1,193,5],[193,7,193,9],[193,11,193,13],[193,15,193,19],[193,21,193,27],[194,9,195,9],[194,11,195,11],[194,12,195,12],[194,1,195,1],[194,2,195,2],[194,3,195,3],[194,4,195,4],[194,5,195,5],[194,19,195,19],[194,21,194,23],[194,24,194,26],[194,27,195,27],[200,2,200,4],[200,7,200,8],[200,11,200,12],[200,15,200,17],[200,21,200,23],[194,13,195,13],[194,15,195,15],[194,16,195,16],[194,17,195,17],[194,18,195,18],[194,7,195,7],[194,8,195,8],[201,2,201,4],[201,7,201,8],[201,11,201,12],[201,15,201,17],[201,21,201,23]]}
[]
[]
[]
[null,null,"Arahan:"]
[null,null,"1. Lampiran 3A ini adalah digunakan untuk membuat pengiraan terhadap Borang JKR.PATA-3A"]
[null,null,"2. Sila kemaskini bahagian yang menggunakan FONT BIRU SAHAJA"]
[null,null,"3. Pengiraan di bawah adalah berdasarkan JKR.PATA-3A jumlah staf UPF (Diisi)",null,null,null,null,null,null,null,null,null,null,"²"]
[]
[null,"Maklumat UPF",null,null,null,null,null,"Pengiraan Kompetensi dan Latihan",null,null,null,null,null,null,null,"Pengiraan Pengurusan Pejabat"]
[null,null,null,null,null,null,null,"1) % staf UPF yang hadir latihan",null,null,null,"2) % staf UPF yang mencapai tahap kompetensi 3 dan ke atas",null,null,null,"3) % Pematuhan ruang/ staf UPF mengikut EPU",null,null,null,null,null,"4) % Perabot asas setiap staf UPF"]
[]
[null,"No","Jawatan","Nama","Tahun lantikan / menyandang","Jumlah Staf UPF yang Diisi",null,"Bilangan Hari Latihan Yang Ditetapkan dalam Setahun (Hari)","Bilangan Hari Yang Telah Dihadiri Sehingga Sukuan Semasa (Hari)","Bilangan Staf Yang Telah Hadir Latihan\n",null,"Kompetensi Pengurusan Aset Tak Alih Yang Ditetapkan","Pencapaian Kompetensi Semasa","Status Pencapaian\n",null,"Gred Jawatan / Jenis Pejabat","Luas Bilik/ Ruang  Pejabat per staf (m²) mengikut Garis Panduan EPU (a)","Luas Bilik/ Ruang Pejabat sekarang per staf (m²) (b)","% Pematuhan ruang/ staf UPF mengikut EPU","Status pematuhan keluasan bilik/ ruang pejabat mengikut EPU\n",null,"Jenis Perabot Asas Pejabat Yang Staf UPF Dapat",null,null,"Format excel",null,null,"Status Perabot Asas Pejabat Staf UPF"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meja","Kerusi","Lain-Lain","Meja","Kerusi","Lain-Lain"]
[null,1,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",{"$f":"IF($C14=\"Sila Pilih\",0,1)","v":0},null,5,0,{"$f":"IFERROR(IF(($I14>=$H14),\"SELESAI\",\"-\"),0)","v":"-"},null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M14,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P14,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,{"$f":"IFERROR($R14/$Q14,\"-\")","v":"-"},{"$f":"IFERROR(IF((AND($S14>=0.85, $S14<=1.15)), \"MEMATUHI\",\"-\"),0)","v":"-"},null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V14,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W14,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X14,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"IFERROR(IF(($Y14+$Z14)=2,\"LENGKAP\",\"TIDAK LENGKAP\"),\"-\")","v":"-"}]
[null,2,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",{"$f":"IF($C15=\"Sila Pilih\",0,1)","v":0},null,5,0,{"$f":"IFERROR(IF(($I15>=$H15),\"SELESAI\",\"-\"),0)","v":"-"},null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M15,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P15,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,{"$f":"IFERROR($R15/$Q15,\"-\")","v":"-"},{"$f":"IFERROR(IF((AND($S15>=0.85, $S15<=1.15)), \"MEMATUHI\",\"-\"),0)","v":"-"},null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V15,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W15,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X15,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"IFERROR(IF((Y15+Z15)=2,\"LENGKAP\",\"TIDAK LENGKAP\"),\"-\")","v":"-"}]
[null,3,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",0,null,5,0,"-",null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M16,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P16,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,"-","-",null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V16,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W16,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X16,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"IFERROR(IF((Y16+Z16)=2,\"LENGKAP\",\"TIDAK LENGKAP\"),\"-\")","v":"-"}]
[null,4,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",0,null,5,0,"-",null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M17,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P17,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,"-","-",null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V17,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W17,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X17,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"IFERROR(IF((Y17+Z17)=2,\"LENGKAP\",\"TIDAK LENGKAP\"),\"-\")","v":"-"}]
[null,5,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",0,null,5,0,"-",null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M18,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P18,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,"-","-",null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V18,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W18,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X18,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"IFERROR(IF((Y18+Z18)=2,\"LENGKAP\",\"TIDAK LENGKAP\"),\"-\")","v":"-"}]
[null,6,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",0,null,5,0,"-",null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M19,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P19,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,"-","-",null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V19,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W19,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X19,TableL3APerabot[],2,FALSE)","v":"-"},"-"]
[null,7,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",0,null,5,0,"-",null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M20,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P20,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,"-","-",null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V20,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W20,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X20,TableL3APerabot[],2,FALSE)","v":"-"},"-"]
[null,8,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",0,null,5,0,"-",null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M21,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P21,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,"-","-",null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V21,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W21,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X21,TableL3APerabot[],2,FALSE)","v":"-"},"-"]
[null,9,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",0,null,5,0,"-",null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M22,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P22,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,"-","-",null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V22,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W22,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X22,TableL3APerabot[],2,FALSE)","v":"-"},"-"]
[null,10,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",0,null,5,0,"-",null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M23,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P23,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,"-","-",null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V23,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W23,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X23,TableL3APerabot[],2,FALSE)","v":"-"},"-"]
[null,11,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",0,null,5,0,"-",null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M24,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P24,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,"-","-",null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V24,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W24,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X24,TableL3APerabot[],2,FALSE)","v":"-"},"-"]
[null,12,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",0,null,5,0,"-",null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M25,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P25,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,"-","-",null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V25,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W25,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X25,TableL3APerabot[],2,FALSE)","v":"-"},"-"]
[null,13,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",0,null,5,0,"-",null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M26,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P26,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,"-","-",null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V26,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W26,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X26,TableL3APerabot[],2,FALSE)","v":"-"},"-"]
[null,14,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",0,null,5,0,"-",null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M27,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P27,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,"-","-",null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V27,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W27,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X27,TableL3APerabot[],2,FALSE)","v":"-"},"-"]
[null,15,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",0,null,5,0,"-",null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M28,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P28,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,"-","-",null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V28,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W28,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X28,TableL3APerabot[],2,FALSE)","v":"-"},"-"]
[null,16,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",0,null,5,0,"-",null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M29,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P29,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,"-","-",null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V29,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W29,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X29,TableL3APerabot[],2,FALSE)","v":"-"},"-"]
[null,17,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",0,null,5,0,"-",null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M30,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P30,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,"-","-",null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V30,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W30,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X30,TableL3APerabot[],2,FALSE)","v":"-"},"-"]
[null,18,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",0,null,5,0,"-",null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M31,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P31,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,"-","-",null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V31,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W31,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X31,TableL3APerabot[],2,FALSE)","v":"-"},"-"]
[null,19,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",0,null,5,0,"-",null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M32,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P32,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,"-","-",null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V32,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W32,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X32,TableL3APerabot[],2,FALSE)","v":"-"},"-"]
[null,20,"Sila Pilih","Sila kemaskini","Sila Isi Tahun",0,null,5,0,"-",null,3,"Sila Pilih Tahap",{"$f":"VLOOKUP($M33,TableL3ATahapKompetensi[],2,FALSE)","v":"-"},null,"Sila Pilih Gred Jawatan",{"$f":"VLOOKUP($P33,TableL3AGredJawatan[],2,FALSE)","v":"-"},0,"-","-",null,"Sila Pilih","Sila Pilih","Sila Pilih",{"$f":"VLOOKUP(V33,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(W33,TableL3APerabot[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(X33,TableL3APerabot[],2,FALSE)","v":"-"},"-"]
[]
[null,null,"Jumlah staf UPF yang diisi",null,null,{"$f":"SUM(F14:F34)","v":0},null,"Jumlah staf UPF yang hadir latihan\n( c )",null,{"$f":"COUNTIF(J14:J34, \"SELESAI\")","v":0},null,"Jumlah staf UPF Staf Yang Telah Mencapai Tahap Kompetensi 3 Dan Ke Atas\n( c )",null,{"$f":"COUNTIF(N14:N34, \"KOMPETEN\")","v":0},null,"Jumlah staf UPF yang mempunyai ruang/ staf mengikut EPU\n( c )",null,null,null,{"$f":"COUNTIF(T14:T34, \"MEMATUHI\")","v":0},null,"Jumlah Staf UPF yang mempunyai Perabot Pejabat Asas lengkap\n( c )",null,null,null,null,null,{"$f":"COUNTIF(AB14:AB34, \"LENGKAP\")","v":0}]
[null,null,"Ruangan Semakan\nJumlah UPF diisi JKR.PATA.3A",null,null,{"$f":"Table3A_M_ST[Diisi (Bil.)  \n(b)]","v":0},null,"% Staf UPF yang hadir latihan\n ( c ) / ( b ) x 100% ",null,{"$f":"IFERROR(J35/$F$35,0%)","v":0},null,"% Staf UPF Staf Yang Telah Mencapai Tahap Kompetensi 3 Dan Ke Atas \n( c ) / ( b ) x 100% ",null,{"$f":"IFERROR(N35/$F$35,0%)","v":0},null,"% Pematuhan ruang/ staf UPF mengikut EPU \n( c ) / ( b ) x 100%",null,null,null,{"$f":"IFERROR(T35/$F$35,0%)","v":0},null,"% Perabot Asas Setiap Staf UPF\n( c ) / ( b ) x 100%",null,null,null,null,null,{"$f":"IFERROR(AB35/$F$35,0%)","v":0}]
[null,null,null,null,null,null,null,null,null,"ke JKR.PATA.3A",null,null,null,"ke JKR.PATA.3A",null,null,null,null,null,"ke JKR.PATA.3A",null,null,null,null,null,null,null,"ke JKR.PATA.3A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Ruangan ini ialah bagi tujuan LINK EXCEL (JANGAN DELETE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Link Drop Down LAMPIRAN 3A",null,null,"*Link Drop Down LAMPIRAN 3A",null,null,"*Link Drop Down LAMPIRAN 3A",null,null,"*Link Drop Down LAMPIRAN 3A",null,null,"*Link Drop Down LAMPIRAN 3A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sila Pilih",null,null,"Sila Pilih",null,null,"Gred","Keluasan bilik",null,"Tahap","Kompetensi",null,"Perabot Asas","value"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PTF",null,null,"Ada",null,null,"Sila Pilih Gred Jawatan","-",null,"Sila Pilih Tahap","-",null,"Ada",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PIF",null,null,"Tiada",null,null,"Utama (JUSA)\"A\" (Bilik)",36,null,"0 - Tiada kesedaran/ kefahaman","-",null,"Tiada",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POF",null,null,null,null,null,"Utama (JUSA)\"B\" dan \"C\" (Bilik)",30,null,"1 - Ada kesedaran/kefahaman","-",null,"Sila Pilih","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PDF",null,null,null,null,null,"53-54 (Bilik)",30,null,"2 - Berkebolehan melaksana kerja dengan seliaan","-"]
[null,null,null,"Disediakan oleh Urus Setia JPAK:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",null,null,null,null,null,"53-54 (Ruang)",16,null,"3 - Berkebolehan melaksana kerja tanpa seliaan","KOMPETEN"]
[null,null,null,"CONTOH PENGISIAN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"47-52 (Bilik)",24,null,"4 - Berkebolehan merancang dan mengurus kerja","KOMPETEN"]
[null,"Maklumat UPF",null,null,null,null,null,"Pengiraan Kompetensi dan Latihan",null,null,null,null,null,null,null,"Pengiraan Pengurusan Pejabat",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"47-52 (Ruang)",14,null,"5 - Amat berkebolehan merancang/mengurus & memimpin organisasi","KOMPETEN"]
[null,null,null,null,null,null,null,"1) % staf UPF yang hadir latihan",null,null,null,"2) % staf UPF yang mencapai tahap kompetensi 3 dan ke atas",null,null,null,"3) % Pematuhan ruang/ staf UPF mengikut EPU",null,null,null,null,null,"4) % Perabot asas setiap staf UPF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ketua Jabatan Gred 41-46 (di luar Ibu Pejabat) (Bilik)",16]
[null,"No","Jawatan","Nama","Tahun lantikan / menyandang","Jumlah Staf UPF yang Diisi",null,"Bilangan Hari Latihan Yang Ditetapkan dalam Setahun (Hari)","Bilangan Hari Yang Telah Dihadiri Sehingga Sukuan Semasa (Hari)","Bilangan Staf Yang Telah Hadir Latihan\n",null,"Kompetensi Pengurusan Aset Tak Alih Yang Ditetapkan","Pencapaian Kompetensi Semasa","Status Pencapaian\n",null,"Gred Jawatan / Jenis Pejabat","Luas Bilik/ Ruang  Pejabat per staf (m²) mengikut Garis Panduan EPU (a)","Luas Bilik/ Ruang Pejabat sekarang per staf (m²) (b)","% Pematuhan ruang/ staf UPF mengikut EPU","Status pematuhan keluasan bilik/ ruang pejabat mengikut EPU\n",null,"Jenis Perabot Asas Pejabat Yang Staf UPF Dapat",null,null,"Format excel",null,null,"Status Perabot Asas Pejabat Staf UPF",null,null,null,null,null,null,null,null,"Lain-lain pegawai yang perlu disediakan bilik atas faktor keselamatan. (Bilik)",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meja","Kerusi","Lain-Lain","Meja","Kerusi","Lain-Lain",null,null,null,null,null,null,null,null,null,"41-46 (Ruang)",12]
[null,1,"PTF","En Tarmizi Bin Mohamad       ",2020,{"$f":"IF($C197=\"Sila Pilih\",0,1)","v":1},null,5,10,{"$f":"IFERROR(IF(($I197>=$H197),\"SELESAI\",\"-\"),0)","v":"SELESAI"},null,3,"4 - Berkebolehan merancang dan mengurus kerja","KOMPETEN",null,"Ketua Jabatan Gred 41-46 (di luar Ibu Pejabat) (Bilik)",16,24,{"$f":"IFERROR($R197/$Q197,\"-\")","v":1.5},{"$f":"IFERROR(IF((AND($S197>=0.85, $S197<=1.15)), \"MEMATUHI\",\"-\"),0)","v":"-"},null,"Ada","Ada","Ada",{"$f":"VLOOKUP(V197,[1]!TableL3APerabot[#Data],2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(W197,[1]!TableL3APerabot[#Data],2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(X197,[1]!TableL3APerabot[#Data],2,FALSE)","v":{"$error":"#REF!"}},"LENGKAP",null,null,null,null,null,null,null,null,"36-40 (Ruang)",8]
[null,2,"PDF","En. Muhamad Noor  Shuhaimi Bin Ramli",2023,{"$f":"IF($C198=\"Sila Pilih\",0,1)","v":1},null,5,3,"-",null,3,"2 - Berkebolehan melaksana kerja dengan seliaan","-",null,"1-35 (Ruang)",4,4,{"$f":"IFERROR($R198/$Q198,\"-\")","v":1},{"$f":"IFERROR(IF((AND($S198>=0.85, $S198<=1.15)), \"MEMATUHI\",\"-\"),0)","v":"MEMATUHI"},null,"Ada","Ada","Ada",{"$f":"VLOOKUP(V198,[1]!TableL3APerabot[#Data],2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(W198,[1]!TableL3APerabot[#Data],2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(X198,[1]!TableL3APerabot[#Data],2,FALSE)","v":{"$error":"#REF!"}},"LENGKAP",null,null,null,null,null,null,null,null,"1-35 (Ruang)",4]
[null,3,"POF","En Ali Amran Bin Abu",2020,1,null,5,3,"-",null,3,"3 - Berkebolehan melaksana kerja tanpa seliaan","KOMPETEN",null,"Ketua Jabatan Gred 41-46 (di luar Ibu Pejabat) (Bilik)",16,10,0.625,"-",null,"Ada","Ada","Ada",{"$f":"VLOOKUP(V199,[1]!TableL3APerabot[#Data],2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(W199,[1]!TableL3APerabot[#Data],2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(X199,[1]!TableL3APerabot[#Data],2,FALSE)","v":{"$error":"#REF!"}},"LENGKAP"]
[null,4,"PIF","Pn. Baizura binti halim",2021,1,null,5,5,"SELESAI",null,3,"3 - Berkebolehan melaksana kerja tanpa seliaan","KOMPETEN",null,"36-40 (Ruang)",8,4,0.5,"-",null,"Ada","Ada","Ada",{"$f":"VLOOKUP(V200,[1]!TableL3APerabot[#Data],2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(W200,[1]!TableL3APerabot[#Data],2,FALSE)","v":{"$error":"#REF!"}},{"$f":"VLOOKUP(X200,[1]!TableL3APerabot[#Data],2,FALSE)","v":{"$error":"#REF!"}},"LENGKAP"]
[null,null,"Jumlah staf UPF yang diisi",null,null,4,null,"Jumlah staf UPF yang hadir latihan\n( c )",null,2,null,"Jumlah staf UPF Staf Yang Telah Mencapai Tahap Kompetensi 3 Dan Ke Atas\n( c )",null,3,null,"Jumlah staf UPF yang mempunyai ruang/ staf mengikut EPU\n( c )",null,null,null,1,null,"Jumlah Staf UPF yang mempunyai Perabot Pejabat Asas lengkap\n( c )",null,null,null,null,null,4]
[null,null,"Ruangan Semakan\nJumlah UPF diisi JKR.PATA.3A",null,null,4,null,"% Staf UPF yang hadir latihan\n ( c ) / ( b ) x 100% ",null,0.5,null,"% Staf UPF Staf Yang Telah Mencapai Tahap Kompetensi 3 Dan Ke Atas \n( c ) / ( b ) x 100% ",null,0.75,null,"% Pematuhan ruang/ staf UPF mengikut EPU \n( c ) / ( b ) x 100%",null,null,null,0.25,null,"% Perabot Asas Setiap Staf UPF\n( c ) / ( b ) x 100%",null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"ke JKR.PATA.3A",null,null,null,"ke JKR.PATA.3A",null,null,null,null,null,"ke JKR.PATA.3A",null,null,null,null,null,null,null,"ke JKR.PATA.3A"]

{"sheet":" PATA 3B (Premis)","index":4,"n_rows":210,"n_cols":47,"rows_kept":210,"cut":false,"hidden":false,"merged":[[12,1,13,1],[12,0,13,0],[11,14,11,20],[11,21,11,27],[11,28,11,34],[12,7,12,13],[12,14,12,20],[12,21,12,27],[13,31,13,34],[13,17,13,20],[13,21,13,23],[13,24,13,27],[13,28,13,30],[11,35,11,41],[11,2,11,6],[11,7,11,13],[2,0,2,41],[1,0,1,41],[3,0,3,41],[4,23,4,24],[17,14,17,18],[17,21,17,25],[17,28,17,32],[17,35,17,39],[12,2,13,6],[13,35,13,37],[13,38,13,41],[12,28,12,34],[12,35,12,41],[13,7,13,9],[13,10,13,13],[13,14,13,16],[205,0,206,0],[205,1,206,1],[205,2,206,6],[205,7,205,13],[205,14,205,20],[205,21,205,27],[205,28,205,34],[205,35,205,41],[206,7,206,9],[206,10,206,13],[206,14,206,16],[206,17,206,20],[206,21,206,23],[206,24,206,27],[206,28,206,30],[206,31,206,34],[206,35,206,37],[206,38,206,41]]}
[]
["JKR.PATA-3B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Ruangan ini ialah bagi tujuan LINK EXCEL (JANGAN DELETE)"]
["LAPORAN KEMAJUAN AKTIVITI PENGURUSAN ASET TAK ALIH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Link Drop Down JKR PATA 3B"]
["(Peringkat Premis)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-","Sila Pilih"]
[null,null,null,null,null,null,null,null,"Bulan   :",null,null,{"$f":"'MUKA HADAPAN'!D5","v":"Sila Pilih"},null,null,null,null,null,null,null,null,null,"Tahun   :",null,{"$f":"'MUKA HADAPAN'!D6","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AJ"]
[null,"Kementerian                 :",{"$f":"'MUKA HADAPAN'!D7","v":"Sila Pilih"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jabatan / Agensi :",null,null,null,{"$f":"'MUKA HADAPAN'!D10","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AA"]
[null,"Negeri/ Wilayah            :",{"$f":"'MUKA HADAPAN'!D8","v":"Sila Pilih"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daerah                :",null,null,null,{"$f":"'MUKA HADAPAN'!D9","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AP"]
[null,"Nama Premis                :",{"$f":"'MUKA HADAPAN'!D11","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LL"]
[null,"No. DPA                        :",{"$f":"'MUKA HADAPAN'!D12","v":"Sila Kemaskini"}]
[]
[null,null,null,null,null,null,null,"Dari JKR.PATA.F6/6",null,null,null,null,null,null,"Dari JKR.PATA.F7/2",null,null,null,null,null,null,"Dari JKR.PATA.F8/5",null,null,null,null,null,null,"Dari JKR.PATA.F9/2",null,null,null,null,null,null,"Dari JKR.PATA.F10/5"]
[null,null,"4. Maklumat Asas Aset",null,null,null,null,"5. Penerimaan Aset ",null,null,null,null,null,null,"6. Operasi dan Penyenggaraan Aset ",null,null,null,null,null,null,"7. Penilaian Aset",null,null,null,null,null,null,"8. Pemulihan/ Pemuliharaan/ Ubah Suai/ Naik Taraf Aset",null,null,null,null,null,null,"9. Pelupusan Aset"]
[null,null,null,null,null,null,null,"Aktiviti",null,null,"Perbelanjaan",null,null,null,"Aktiviti",null,null,"Perbelanjaan",null,null,null,"Aktiviti",null,null,"Perbelanjaan",null,null,null,"Aktiviti",null,null,"Perbelanjaan",null,null,null,"Aktiviti",null,null,"Perbelanjaan"]
["Bil.\nM3B","Premis\nM3B.","Kategori Premis Aset* M4.","Jenis pemilikan aset M4.","Bilangan Premis Aset M4.","Saiz Premis (luas/panjang) (m²/km) M4.","Populasi (Bil.) M4.","Rancang (Bil.) \n(a) M5.","Laksana (Bil.)  \n(b) M5.","% Pencapaian \n(b)/(a) M5.","Mohon (RM) M5.","Terima (RM) \n( c) M5.","Jumlah Belanja (RM) \n(d) M5.","% Perbelanjaan  \n(d) / ( c) M5.","Rancang (Bil.) \n(a) M6.","Laksana (Bil.)  \n(b) M6.","% Pencapaian \n(b)/(a) M6.","Mohon (RM) M6.","Terima (RM) \n( c) M6.","Jumlah Belanja (RM) \n(d) M6.","% Perbelanjaan \n(d) / ( c) M6.","Rancang (Bil.) \n(a) M7.","Laksana (Bil.)  \n(b) M7.","% Pencapaian \n(b)/(a) M7.","Mohon (RM) M7.","Terima (RM)\n( c) M7.","Jumlah Belanja (RM)\n(d) M7.","% Perbelanjaan \n(d) / ( c)  M7.","Rancang (Bil.) \n(a) M8.","Laksana (Bil.)  \n(b) M8.","% Pencapaian \n(b)/(a) M8.","Mohon (RM) M8.","Terima (RM) \n( c) M8.","Jumlah Belanja (RM) \n( d) M8.","% Perbelanjaan \n(d) / ( c) M8.","Rancang (Bil.)\n(a) M9.","Laksana (Bil.)  \n(b) M9.","% Pencapaian\n(b)/( a) M9.","Mohon (RM) M9.","Terima (RM) \n( c) M9.","Jumlah Belanja (RM) \n( d) M9.","% Perbelanjaan \n(d) / ( c) M9."]
[null,{"$f":"Table3A_M_ST[Premis]","v":"Sila Kemaskini"},{"$f":"IFERROR(IF((Table3B_M_ST[[#This Row],[Jenis pemilikan aset M4.]]=\"-\"),\"-\",\"AB\"),0)","v":"-"},{"$f":"Table3A_M_ST[[#This Row],[Jenis pemilikan aset]]","v":"-"},{"$f":"Table3A_M_ST[[#This Row],[Bilangan Premis Aset]]","v":0},0,0,{"$f":"T_F6_6DAK[[#Totals],[Rancang (Bil.) \n(a) ]]","v":0},{"$f":"T_F6_6DAK[[#Totals],[Laksana (Bil.)  \n(b) ]]","v":0},{"$f":"IFERROR(I16/H16,0%)","v":0},{"$f":"T_F6_6DAK[[#Totals],[Mohon (RM) ]]","v":0},{"$f":"T_F6_6DAK[[#Totals],[Terima (RM) \n( c) ]]","v":0},{"$f":"T_F6_6DAK[[#Totals],[Jumlah Belanja (RM) \n(d) ]]","v":0},{"$f":"IFERROR($M16/$L16,0%)","v":0},{"$f":"T_F7_2[[#Totals],[Rancang (Bil.) \n(a)]]","v":0},{"$f":"T_F7_2[[#Totals],[Laksana (Bil.)  \n(b) ]]","v":0},{"$f":"IFERROR($P16/$O16,0%)","v":0},{"$f":"T_F7_2[[#Totals],[Mohon (RM) ]]","v":0},{"$f":"T_F7_2[[#Totals],[Terima (RM) \n( c) ]]","v":0},{"$f":"T_F7_2[[#Totals],[Jumlah Belanja (RM) \n(d) M6.]]","v":0},{"$f":"IFERROR($T16/$S16,0%)","v":0},{"$f":"T_F8_5[[#Totals],[Rancang (Bil.) \n(a)]]","v":0},{"$f":"T_F8_5[[#Totals],[Laksana (Bil.)  \n(b) ]]","v":0},{"$f":"IFERROR($W16/$V16,0%)","v":0},{"$f":"T_F8_5[[#Totals],[Mohon (RM) ]]","v":0},{"$f":"T_F8_5[[#Totals],[Terima (RM)\n( c) ]]","v":0},{"$f":"T_F8_5[[#Totals],[Jumlah Belanja (RM)\n(d) ]]","v":0},{"$f":"IFERROR($AA16/$Z16,0%)","v":0},{"$f":"T_F9_2[[#Totals],[Rancang (Bil.) \n(a) M8.]]","v":0},{"$f":"T_F9_2[[#Totals],[Laksana (Bil.)  \n(b) M8.]]","v":0},{"$f":"IFERROR($AD16/$AC16,0%)","v":0},{"$f":"T_F9_2[[#Totals],[Mohon (RM) ]]","v":0},{"$f":"T_F9_2[[#Totals],[Terima (RM) \n( c)]]","v":0},{"$f":"T_F9_2[[#Totals],[Jumlah Belanja (RM) \n( d) ]]","v":0},{"$f":"IFERROR($AH16/$AG16,0%)","v":0},{"$f":"T_F10_5[[#Totals],[Rancang (Bil.)\n(a) ]]","v":0},{"$f":"T_F10_5[[#Totals],[Laksana (Bil.)  \n(b) ]]","v":0},{"$f":"IFERROR($AK16/$AJ16,0%)","v":0},{"$f":"T_F10_5[[#Totals],[Mohon (RM) ]]","v":0},{"$f":"T_F10_5[[#Totals],[Terima (RM) \n( c) ]]","v":0},{"$f":"T_F10_5[[#Totals],[Jumlah Belanja (RM) \n( d) ]]","v":0},{"$f":"IFERROR($AO16/$AN16,0%)","v":0}]
["1",{"$f":"Table3B_M_ST[Premis\nM3B.]","v":"Sila Kemaskini"},{"$f":"C16","v":"-"},{"$f":"Table3B_M_ST[Jenis pemilikan aset M4.]","v":"-"},{"$f":"SUBTOTAL(109,Table3B_M_ST[Bilangan Premis Aset M4.])","v":0},{"$f":"SUBTOTAL(109,Table3B_M_ST[Saiz Premis (luas/panjang) (m²/km) M4.])","v":0},{"$f":"SUBTOTAL(109,Table3B_M_ST[Populasi (Bil.) M4.])","v":0},{"$f":"Table3B_M_ST[Rancang (Bil.) \n(a) M5.]","v":0},{"$f":"Table3B_M_ST[Laksana (Bil.)  \n(b) M5.]","v":0},{"$f":"IFERROR(I17/Table3B_M_ST[[#Totals],[Rancang (Bil.) \n(a) M5.]],0%)","v":0},{"$f":"SUBTOTAL(109,Table3B_M_ST[Mohon (RM) M5.])","v":0},{"$f":"Table3B_M_ST[Terima (RM) \n( c) M5.]","v":0},{"$f":"SUBTOTAL(109,Table3B_M_ST[Jumlah Belanja (RM) \n(d) M5.])","v":0},{"$f":"IFERROR(Table3B_M_ST[[#Totals],[Jumlah Belanja (RM) \n(d) M5.]]/Table3B_M_ST[[#Totals],[Terima (RM) \n( c) M5.]],0%)","v":0},{"$f":"Table3B_M_ST[Rancang (Bil.) \n(a) M6.]","v":0},{"$f":"Table3B_M_ST[Laksana (Bil.)  \n(b) M6.]","v":0},{"$f":"IFERROR(Table3B_M_ST[[#Totals],[Laksana (Bil.)  \n(b) M6.]]/Table3B_M_ST[[#Totals],[Rancang (Bil.) \n(a) M6.]],0%)","v":0},{"$f":"SUBTOTAL(109,Table3B_M_ST[Mohon (RM) M6.])","v":0},{"$f":"SUBTOTAL(109,Table3B_M_ST[Terima (RM) \n( c) M6.])","v":0},{"$f":"SUBTOTAL(109,Table3B_M_ST[Jumlah Belanja (RM) \n(d) M6.])","v":0},{"$f":"IFERROR(Table3B_M_ST[[#Totals],[Jumlah Belanja (RM) \n(d) M6.]]/Table3B_M_ST[[#Totals],[Terima (RM) \n( c) M6.]],0%)","v":0},{"$f":"Table3B_M_ST[Rancang (Bil.) \n(a) M7.]","v":0},{"$f":"Table3B_M_ST[Laksana (Bil.)  \n(b) M7.]","v":0},{"$f":"IFERROR(Table3B_M_ST[[#Totals],[Laksana (Bil.)  \n(b) M7.]]/Table3B_M_ST[[#Totals],[Rancang (Bil.) \n(a) M7.]],0%)","v":0},{"$f":"SUBTOTAL(109,Table3B_M_ST[Mohon (RM) M7.])","v":0},{"$f":"SUBTOTAL(109,Table3B_M_ST[Terima (RM)\n( c) M7.])","v":0},{"$f":"SUBTOTAL(109,Table3B_M_ST[Jumlah Belanja (RM)\n(d) M7.])","v":0},{"$f":"IFERROR(Table3B_M_ST[[#Totals],[Jumlah Belanja (RM)\n(d) M7.]]/Table3B_M_ST[[#Totals],[Terima (RM)\n( c) M7.]],0%)","v":0},{"$f":"Table3B_M_ST[Rancang (Bil.) \n(a) M8.]","v":0},{"$f":"Table3B_M_ST[Laksana (Bil.)  \n(b) M8.]","v":0},{"$f":"IFERROR(Table3B_M_ST[[#Totals],[Laksana (Bil.)  \n(b) M8.]]/Table3B_M_ST[[#Totals],[Rancang (Bil.) \n(a) M8.]],0%)","v":0},{"$f":"SUBTOTAL(109,Table3B_M_ST[Mohon (RM) M8.])","v":0},{"$f":"SUBTOTAL(109,Table3B_M_ST[Terima (RM) \n( c) M8.])","v":0},{"$f":"SUBTOTAL(109,Table3B_M_ST[Jumlah Belanja (RM) \n( d) M8.])","v":0},{"$f":"IFERROR(Table3B_M_ST[[#Totals],[Jumlah Belanja (RM) \n( d) M8.]]/Table3B_M_ST[[#Totals],[Terima (RM) \n( c) M8.]],0%)","v":0},{"$f":"Table3B_M_ST[Rancang (Bil.)\n(a) M9.]","v":0},{"$f":"Table3B_M_ST[Laksana (Bil.)  \n(b) M9.]","v":0},{"$f":"IFERROR(Table3B_M_ST[[#Totals],[Laksana (Bil.)  \n(b) M9.]]/Table3B_M_ST[[#Totals],[Rancang (Bil.)\n(a) M9.]],0%)","v":0},{"$f":"SUBTOTAL(109,Table3B_M_ST[Mohon (RM) M9.])","v":0},{"$f":"SUBTOTAL(109,Table3B_M_ST[Terima (RM) \n( c) M9.])","v":0},{"$f":"SUBTOTAL(109,Table3B_M_ST[Jumlah Belanja (RM) \n( d) M9.])","v":0},{"$f":"IFERROR(Table3B_M_ST[[#Totals],[Jumlah Belanja (RM) \n( d) M9.]]/Table3B_M_ST[[#Totals],[Terima (RM) \n( c) M9.]],0%)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null," (i) ",null,null,null,null,null,null," (ii) ",null,null,null,null,null,null," (iii) ",null,null,null,null,null,null," (iv) ",null,null,null,null,null,null,"(v)"]
[null,"  Petunjuk: *Kategori Premis Aset; AB- Aset Bangunan, AJ-Aset Jalan, AA-Aset Air dan, AP- Aset Pembentungan."]
[]
[null,"  Disediakan Oleh :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disahkan  Oleh :"]
[]
[]
[null,"  (cap nama & jawatan)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(cap nama & jawatan)"]
[null,"  Tarikh :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tarikh :"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Ruangan ini ialah bagi tujuan LINK EXCEL (JANGAN DELETE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kategori Premis Aset:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AJ"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LL"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Disediakan oleh Urus Setia JPAK:"]
[null,"CONTOH PENGISIAN"]
[]
[null,null,"4. Maklumat Asas Aset",null,null,null,null,"5. Penerimaan Aset ",null,null,null,null,null,null,"6. Operasi dan Penyenggaraan Aset ",null,null,null,null,null,null,"7. Penilaian Aset",null,null,null,null,null,null,"8. Pemulihan/ Pemuliharaan/ Ubah Suai/ Naik Taraf Aset",null,null,null,null,null,null,"9. Pelupusan Aset"]
[null,null,null,null,null,null,null,"Aktiviti",null,null,"Perbelanjaan",null,null,null,"Aktiviti",null,null,"Perbelanjaan",null,null,null,"Aktiviti",null,null,"Perbelanjaan",null,null,null,"Aktiviti",null,null,"Perbelanjaan",null,null,null,"Aktiviti",null,null,"Perbelanjaan"]
["Bil.\n","Premis\n","Kategori Premis Aset* ","Jenis pemilikan aset ","Bilangan Premis Aset ","Saiz Premis (luas/panjang) (m²/km) M4.","Populasi (Bil.) ","Rancang (Bil.) \n(a)","Laksana (Bil.)  \n(b) ","% Pencapaian \n(b)/(a) ","Mohon (RM) ","Terima (RM) \n( c)","Jumlah Belanja (RM) \n(d) ","% Perbelanjaan  \n(d) / ( c) ","Rancang (Bil.) \n(a) ","Laksana (Bil.)  \n(b) ","% Pencapaian \n(b)/(a) ","Mohon (RM) ","Terima (RM) \n( c)","Jumlah Belanja (RM) \n(d) ","% Perbelanjaan \n(d) / ( c) ","Rancang (Bil.) \n(a) ","Laksana (Bil.)  \n(b)","% Pencapaian \n(b)/(a) ","Mohon (RM) ","Terima (RM)\n( c) ","Jumlah Belanja (RM)\n(d) ","% Perbelanjaan \n(d) / ( c)  ","Rancang (Bil.) \n(a) ","Laksana (Bil.)  \n(b) ","% Pencapaian \n(b)/(a) ","Mohon (RM) ","Terima (RM) \n( c) ","Jumlah Belanja (RM) \n( d) ","% Perbelanjaan \n(d) / ( c)","Rancang (Bil.)\n(a) ","Laksana (Bil.)  \n(b) ","% Pencapaian\n(b)/( a) ","Mohon (RM) ","Terima (RM) \n( c) ","Jumlah Belanja (RM) \n( d)","% Perbelanjaan \n(d) / ( c) "]
[null,"IBU PEJABAT POLIS DAERAH KLUANG JOHOR","AB","M",1,4500,1250,2,2,1,1300,1300,1300,1,8,8,1,1635750,1439780,1327250,0.92184222589562292,2,2,1,0,0,0,0,2,2,1,700000,650000,275000,0.42307692307692307,2,2,1,5000,5000,5000,1]
["1","IBU PEJABAT POLIS DAERAH KLUANG JOHOR","AB","M",1,4500,1250,{"$f":"H209","v":2},{"$f":"I209","v":2},1,1300,1300,1300,1,{"$f":"O209","v":8},{"$f":"P209","v":8},1,1635750,1439780,1327250,0.92184222589562292,{"$f":"V209","v":2},{"$f":"W209","v":2},1,0,0,0,0,{"$f":"AC209","v":2},{"$f":"AD209","v":2},1,700000,650000,275000,0.42307692307692307,{"$f":"AJ209","v":2},{"$f":"AK209","v":2},1,5000,5000,5000,1]

{"sheet":"F6 6 (PENERIMAAN)","index":5,"n_rows":225,"n_cols":22,"rows_kept":225,"cut":false,"hidden":false,"merged":[[219,5,219,7],[219,8,219,11],[219,12,219,13],[219,14,219,15],[1,1,1,15],[2,1,2,15],[3,1,3,15],[25,13,27,14],[11,12,11,15],[7,12,7,15],[12,14,12,15],[12,5,12,7],[12,8,12,11],[12,12,12,13]]}
[]
[null,"JKR.PATA.F6/6"]
[null,"LAPORAN PENERIMAAN ASET"]
[null,"(Peringkat Premis)"]
[null,null,null,"Bulan :",{"$f":"'MUKA HADAPAN'!$D$5","v":"Sila Pilih"},null,null,"Tahun :",{"$f":"'MUKA HADAPAN'!$D$6","v":"Sila Kemaskini"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Link Drop Down Kategori",null,"*Link Drop Down K"]
[null,"Kementerian                            :",{"$f":"'MUKA HADAPAN'!$D$7","v":"Sila Pilih"},null,null,null,null,null,null,"Jabatan/ Agensi :     ",{"$f":"'MUKA HADAPAN'!$D$10","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,"Sila Pilih",null,"√"]
[null,"Negeri/ Wilayah                       :",{"$f":"'MUKA HADAPAN'!$D$8","v":"Sila Pilih"},null,null,null,null,null,null,"Daerah : ",{"$f":"'MUKA HADAPAN'!$D$9","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,"Daftar Premis Aset (DPA) ",null,"-"]
[null,"Nama Premis                          :",{"$f":"'MUKA HADAPAN'!$D$11","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daftar Aset Khusus (DAK) "]
[null,"No. DPA (Jika Ada)                 :",{"$f":"'MUKA HADAPAN'!$D$12","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,"Skop Penerimaan Aset","Daftar Aset Khusus (DAK) "]
[]
[null,null,null,null,null,"Pencapaian Penerimaan ",null,null,"Kos / Peruntukan",null,null,null,"Sijil Penerimaan Aset",null,"Dokumen Penerimaan Aset"]
[null,"Aktiviti","Saiz/ Kapasiti","Kuantiti","Kos Perolehan Aset (RM)","Rancang (Bil.) \n(a) ","Laksana (Bil.)  \n(b) ","% Pencapaian \n(b)/(a)","Mohon (RM) ","Terima (RM) \n( c) ","Jumlah Belanja (RM) \n(d) ","% Perbelanjaan  \n(d) / ( c) ","Ya","Tarikh Sijil Dikeluarkan","Lengkap","Tidak Lengkap"]
[null,"Sila masukkan butiran aktiviti","-","-",0,0,0,{"$f":"IFERROR($G15/$F15,0%)","v":0},0,0,0,{"$f":"IFERROR($K15/$J15,0%)","v":0},"-","00:00:00","-","-"]
[null,"Sila masukkan butiran aktiviti","-","-",0,0,0,0,0,0,0,0,"-","00:00:00","-","-"]
[null,"Sila masukkan butiran aktiviti","-","-",0,0,0,0,0,0,0,0,"-","00:00:00","-","-"]
[null,"Sila masukkan butiran aktiviti","-","-",0,0,0,0,0,0,0,0,"-","00:00:00","-","-"]
[null,"Sila masukkan butiran aktiviti","-","-",0,0,0,0,0,0,0,0,"-","00:00:00","-","-"]
[null,"Sila masukkan butiran aktiviti","-","-",0,0,0,0,0,0,0,0,"-","00:00:00","-","-"]
[null,"Jumlah",null,{"$f":"SUBTOTAL(109,T_F6_6DAK[Kuantiti])","v":0},{"$f":"SUBTOTAL(109,T_F6_6DAK[Kos Perolehan Aset (RM)])","v":0},{"$f":"SUBTOTAL(109,T_F6_6DAK[Rancang (Bil.) \n(a) ])","v":0},{"$f":"SUBTOTAL(109,T_F6_6DAK[Laksana (Bil.)  \n(b) ])","v":0},{"$f":"IFERROR($G21/$F21,0%)","v":0},{"$f":"SUBTOTAL(109,T_F6_6DAK[Mohon (RM) ])","v":0},{"$f":"SUBTOTAL(109,T_F6_6DAK[Terima (RM) \n( c) ])","v":0},{"$f":"SUBTOTAL(109,T_F6_6DAK[Jumlah Belanja (RM) \n(d) ])","v":0},{"$f":"IFERROR($K21/$J21,0%)","v":0},null,null,{"$f":"COUNTIF(T_F6_6DAK[Lengkap],\"√\")","v":0},{"$f":"COUNTIF(T_F6_6DAK[Tidak Lengkap],\"√\")","v":0}]
[null,null,null,null,null,"Data ini dibawa ke JKR .PATA-3B (Penerimaan Aset)"]
[]
[]
[null,"Disediakan Oleh:",null,null,null,null,null,null,null,null,null,null,null,"Disahkan Oleh :"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"(PTF)"]
[null,"(cap nama, jawatan)",null,null,null,null,null,null,null,null,null,null,null,"(cap nama, jawatan)"]
[null,"Tarikh : "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Tarikh :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Disediakan oleh Urus Setia JPAK:"]
[null,"CONTOH PENGISIAN"]
[null,null,null,null,null,"Pencapaian Penerimaan ",null,null,"Kos / Peruntukan",null,null,null,"Sijil Penerimaan Aset",null,"Dokumen Penerimaan Aset"]
[null,"Aktiviti","Saiz/ Kapasiti","Kuantiti","Kos Perolehan Aset (RM)","Rancang (Bil.) \n(a) ","Laksana (Bil.)  \n(b) ","% Pencapaian \n(b)/(a)","Mohon (RM) ","Terima (RM) \n( c) ","Jumlah Belanja (RM) \n(d) ","% Perbelanjaan  \n(d) / ( c) ","Ya","Tarikh Sijil Dikeluarkan","Lengkap","Tidak Lengkap"]
[null,"CONTOH PENERIMAAN DAK"]
[null,"Penerimaan 1 unit Penghawa Dingin 5 HP baharu kepada IPD Kluang","5 HP",1,8000,1,1,1,0,0,0,0,"√","2023-04-30","√","-"]
[null,"CONTOH PENERIMAAN DPA"]
[null,"Cadangan Pembinaan Pondok Polis Bukit Permai , Kluang , Johor","500 m2",1,900000,1,1,1,1300,1300,1300,1,"√","2023-08-16","√","-"]

{"sheet":"F7 2 (OPERASI)","index":6,"n_rows":253,"n_cols":44,"rows_kept":253,"cut":false,"hidden":false,"merged":[[12,4,12,9],[8,24,8,26],[7,13,7,14],[7,24,7,26],[14,20,14,23],[14,24,14,26],[2,1,2,32],[3,1,3,32],[4,1,4,32],[9,23,9,26],[10,25,10,26],[39,21,41,22],[39,28,41,29],[34,10,34,16],[39,1,41,3],[14,8,14,9],[13,1,14,3],[13,4,13,9],[13,10,13,16],[13,17,13,32],[14,17,14,19],[14,27,14,31],[14,10,14,12],[14,13,14,16],[240,1,241,3],[240,4,240,9],[240,10,240,16],[240,17,240,32],[241,8,241,9],[241,10,241,12],[241,13,241,16],[241,17,241,19],[241,20,241,23],[241,24,241,26],[241,27,241,31],[241,4,241,7],[251,1,251,2],[242,1,242,3],[243,1,243,2],[245,1,245,2],[247,1,247,2],[249,1,249,2]]}
[]
[]
[null,"JKR.PATA.F7/2"]
[null,"LAPORAN PENYENGGARAAN DAN PERBELANJAAN ASET TAK ALIH"]
[null,"(Peringkat Premis)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Bulan:",{"$f":"'MUKA HADAPAN'!$D$5","v":"Sila Pilih"},null,null,null,null,null,null,null,null,null,"Tahun:",{"$f":"'MUKA HADAPAN'!$D$6","v":"Sila Kemaskini"}]
[]
[null,"Kementerian      :",{"$f":"'MUKA HADAPAN'!$D$7","v":"Sila Pilih"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jabatan/ Agensi : ",null,null,{"$f":"'MUKA HADAPAN'!$D$10","v":"Sila Kemaskini"}]
[null,"Negeri/ Wilayah :",{"$f":"'MUKA HADAPAN'!$D$8","v":"Sila Pilih"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Daerah : ",null,null,{"$f":"'MUKA HADAPAN'!$D$9","v":"Sila Kemaskini"}]
[null,"Nama Premis    :",{"$f":"'MUKA HADAPAN'!$D$11","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saiz Premis (luas/panjang) :"]
[null,"No. DPA                  :",{"$f":"'MUKA HADAPAN'!$D$12","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Populasi :"]
[]
[null,null,null,null,"MAKLUMAT TAMBAHAN"]
[null,"Skop/ Aktiviti/ Butiran Aktiviti",null,null,"Maklumat Kontrak ",null,null,null,null,null,"POPA & Bajet Tahunan",null,null,null,null,null,null,"KPI Penyenggaraan"]
[null,null,null,null,null,null,null,null,"Pihak Yang Berkaitan",null,"Program Operasi dan Penyenggaraan Aset",null,null,"Anggaran Belanjawan Mengurus\nOperasi dan Penyenggaraan Aset",null,null,null,"Operasi Aset",null,null,"Penyenggaraan Pembaikan (PyB)",null,null,null,"Penyenggaraan Pencegahan (PyC)",null,null,"Kajian Kepuasan\n(KK)\n",null,null,null,null,"Pencapaian KPI Penyenggaraan"]
[null,"Skop","Aktiviti","Butiran Aktiviti","Tarikh Mula","Tarikh Siap","Nilai Kontrak (RM)","No. Kontrak","Pihak Yang Menguruskan","Kontraktor","Rancang (Bil.) \n(a)","Laksana (Bil.)  \n(b) ","% Pencapaian \n(b)/(a) ","Mohon (RM) ","Terima (RM) \n( c) ","Jumlah Belanja (RM) \n(d) M6.","% Perbelanjaan \n(d) / ( c) ","Bil. aktiviti Operasi Aset yang dilaksanakan","Bil. aktiviti Operasi Aset yang dirancang","PI Operasi Aset (OA) (%)","Bil. aduan kerosakan mengikut tempoh respon ASL (a)","Bil. aduan kerosakan ditutup mengikut ASL","Bil. aduan kerosakan keseluruhan","PI Penyenggaraan Pembaikan (PyB) (%)","Bil. PPM yang dilaksanakan","Bil. PPM yang dijadualkan","PI Penyenggaraan Pencegahan (PyC) (%) ","Bil. respoden CSS yang berpuas hati","Bil. keseluruhan responden CSS","Bil. respoden SSS yang berpuas hati","Bil. keseluruhan responden SSS","PI Kajian Kepuasan (KK) (%)","Jumlah markah keseluruhan (%) \nPI (OA + PyB + PyC + KK)"]
[null,"Sila Pilih Skop","Sila Pilih","Sila masukkan butiran aktiviti","00:00:00","00:00:00",0,0,"-","-",0,0,{"$f":"IFERROR($L17/$K17,0%)","v":0},0,0,0,{"$f":"IFERROR($P17/$O17,0%)","v":0},0,0,{"$f":"IFERROR(($S17/$R17*0.2),0%)","v":0},0,0,0,{"$f":"IFERROR(((U17/W17)*0.05)+((V17/W17)*0.15),0%)","v":0},0,0,{"$f":"IFERROR(((Y17/Z17)*0.2),0%)","v":0},0,0,0,0,{"$f":"IFERROR((($AB17/$AC17)*0.2)+(($AD17/$AE17)*0.2),0%)","v":0},{"$f":"$X17+$AA17+$AF17+T_F7_2[[#This Row],[PI Operasi Aset (OA) (%)]]","v":0}]
[null,"Sila Pilih Skop","Sila Pilih","Sila masukkan butiran aktiviti","00:00:00","00:00:00",0,0,"-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(((U18/W18)*0.05)+((V18/W18)*0.15),0%)","v":0},0,0,{"$f":"IFERROR(((Y18/Z18)*0.2),0%)","v":0},0,0,0,0,0,{"$f":"$X18+$AA18+$AF18+T_F7_2[[#This Row],[PI Operasi Aset (OA) (%)]]","v":0}]
[null,"Sila Pilih Skop","Sila Pilih","Sila masukkan butiran aktiviti","00:00:00","00:00:00",0,0,"-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(((U19/W19)*0.05)+((V19/W19)*0.15),0%)","v":0},0,0,{"$f":"IFERROR(((Y19/Z19)*0.2),0%)","v":0},0,0,0,0,0,{"$f":"$X19+$AA19+$AF19+T_F7_2[[#This Row],[PI Operasi Aset (OA) (%)]]","v":0}]
[null,"Sila Pilih Skop","Sila Pilih","Sila masukkan butiran aktiviti","00:00:00","00:00:00",0,0,"-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(((U20/W20)*0.05)+((V20/W20)*0.15),0%)","v":0},0,0,{"$f":"IFERROR(((Y20/Z20)*0.2),0%)","v":0},0,0,0,0,0,{"$f":"$X20+$AA20+$AF20+T_F7_2[[#This Row],[PI Operasi Aset (OA) (%)]]","v":0}]
[null,"Sila Pilih Skop","Sila Pilih","Sila masukkan butiran aktiviti","00:00:00","00:00:00",0,0,"-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(((U21/W21)*0.05)+((V21/W21)*0.15),0%)","v":0},0,0,{"$f":"IFERROR(((Y21/Z21)*0.2),0%)","v":0},0,0,0,0,0,{"$f":"$X21+$AA21+$AF21+T_F7_2[[#This Row],[PI Operasi Aset (OA) (%)]]","v":0}]
[null,"Sila Pilih Skop","Sila Pilih","Sila masukkan butiran aktiviti","00:00:00","00:00:00",0,0,"-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(((U22/W22)*0.05)+((V22/W22)*0.15),0%)","v":0},0,0,{"$f":"IFERROR(((Y22/Z22)*0.2),0%)","v":0},0,0,0,0,0,{"$f":"$X22+$AA22+$AF22+T_F7_2[[#This Row],[PI Operasi Aset (OA) (%)]]","v":0}]
[null,"Sila Pilih Skop","Sila Pilih","Sila masukkan butiran aktiviti","00:00:00","00:00:00",0,0,"-","-",0,0,0,0,0,0,0,0,0,{"$f":"IFERROR(($S23/$R23*0.2),0%)","v":0},0,0,0,{"$f":"IFERROR(((U23/W23)*0.05)+((V23/W23)*0.15),0%)","v":0},0,0,{"$f":"IFERROR(((Y23/Z23)*0.2),0%)","v":0},0,0,0,0,{"$f":"IFERROR((($AB23/$AC23)*0.2)+(($AD23/$AE23)*0.2),0%)","v":0},{"$f":"$X23+$AA23+$AF23+T_F7_2[[#This Row],[PI Operasi Aset (OA) (%)]]","v":0}]
[null,"Sila Pilih Skop","Sila Pilih","Sila masukkan butiran aktiviti","00:00:00","00:00:00",0,0,"-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$X24+$AA24+$AF24+T_F7_2[[#This Row],[PI Operasi Aset (OA) (%)]]","v":0}]
[null,"Sila Pilih Skop","Sila Pilih","Sila masukkan butiran aktiviti","00:00:00","00:00:00",0,0,"-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$X25+$AA25+$AF25+T_F7_2[[#This Row],[PI Operasi Aset (OA) (%)]]","v":0}]
[null,"Sila Pilih Skop","Sila Pilih","Sila masukkan butiran aktiviti","00:00:00","00:00:00",0,0,"-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$X26+$AA26+$AF26+T_F7_2[[#This Row],[PI Operasi Aset (OA) (%)]]","v":0}]
[null,"Sila Pilih Skop","Sila Pilih","Sila masukkan butiran aktiviti","00:00:00","00:00:00",0,0,"-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$X27+$AA27+$AF27+T_F7_2[[#This Row],[PI Operasi Aset (OA) (%)]]","v":0}]
[null,"Sila Pilih Skop","Sila Pilih","Sila masukkan butiran aktiviti","00:00:00","00:00:00",0,0,"-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$X28+$AA28+$AF28+T_F7_2[[#This Row],[PI Operasi Aset (OA) (%)]]","v":0}]
[null,"Sila Pilih Skop","Sila Pilih","Sila masukkan butiran aktiviti","00:00:00","00:00:00",0,0,"-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$X29+$AA29+$AF29+T_F7_2[[#This Row],[PI Operasi Aset (OA) (%)]]","v":0}]
[null,"Sila Pilih Skop","Sila Pilih","Sila masukkan butiran aktiviti","00:00:00","00:00:00",0,0,"-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$X30+$AA30+$AF30+T_F7_2[[#This Row],[PI Operasi Aset (OA) (%)]]","v":0}]
[null,"Sila Pilih Skop","Sila Pilih","Sila masukkan butiran aktiviti","00:00:00","00:00:00",0,0,"-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$X31+$AA31+$AF31+T_F7_2[[#This Row],[PI Operasi Aset (OA) (%)]]","v":0}]
[null,"Sila Pilih Skop","Sila Pilih","Sila masukkan butiran aktiviti","00:00:00","00:00:00",0,0,"-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$X32+$AA32+$AF32+T_F7_2[[#This Row],[PI Operasi Aset (OA) (%)]]","v":0}]
[null,"Sila Pilih Skop","Sila Pilih","Sila masukkan butiran aktiviti","00:00:00","00:00:00",0,0,"-","-",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"$X33+$AA33+$AF33+T_F7_2[[#This Row],[PI Operasi Aset (OA) (%)]]","v":0}]
[null,"Jumlah",null,null,null,null,{"$f":"SUBTOTAL(109,T_F7_2[Nilai Kontrak (RM)])","v":0},null,null,null,{"$f":"SUBTOTAL(109,T_F7_2[Rancang (Bil.) \n(a)])","v":0},{"$f":"SUBTOTAL(109,T_F7_2[Laksana (Bil.)  \n(b) ])","v":0},{"$f":"IFERROR($L34/$K34,0%)","v":0},{"$f":"SUBTOTAL(109,T_F7_2[Mohon (RM) ])","v":0},{"$f":"SUBTOTAL(109,T_F7_2[Terima (RM) \n( c) ])","v":0},{"$f":"SUBTOTAL(109,T_F7_2[Jumlah Belanja (RM) \n(d) M6.])","v":0},{"$f":"IFERROR($P34/$O34,0%)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Data ini dibawa ke JKR.PATA-3B (Operasi & Penyenggaraan)"]
[]
[null,"Nota: Pengukuran KPI Penyenggaraan dan penentuan Tahap Prestasi Penyenggaraan Aset hendaklah merujuk Garis Panduan yang berkuatkuasa"]
[]
[null,"Disediakan Oleh:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disahkan Oleh :"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(PTF)"]
[null,"(cap nama, jawatan)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(cap nama, jawatan)"]
[null,"Tarikh : "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tarikh :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Ruangan ini ialah bagi tujuan LINK EXCEL (JANGAN DELETE)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Link Drop Down Skop Penyengaraan"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Sila Pilih Skop","SKOP : OPERASI ASET","SKOP : PENYENGARAAN PEMBAIKAN (PyB)","SKOP: PENYENGARAAN PENCEGAHAN (PyC)","SKOP :-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Sila Pilih","A1- Pengurusan Pengemasan (Housekeeping)","B1- Secara Jangkaan","C1- Sivil dan Struktur","Kontrak Pengurusan Fasiliti dan Penyenggaraan Bangunan (FMM) (sekiranya ada)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"-","A2- Pengurusan Kawalan Keselamatan","B2- Secara Luar Jangka","C2- Mekanikal","Kontrak Konsesi (sekiranya ada)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"A3- Pengurusan Kawalan Makhluk Perosak","-","C3- Elektrikal","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,"A4- Pengurusan Landskap",null,"C4-  Infrastruktur Teknologi Maklumat (ICT)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"A5- Pengurusan Utiliti",null,"C5-  Kemasan dan Seni Bina"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,"A6- Pengurusan Tenaga",null,"C6- Lain-lain (nyatakan: )"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,"A7- Pengurusan Sisa Buangan",null,"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,"A8- Pengurusan Parkir dan Trafik"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,"A9- Pengurusan Ruang"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,"A10- Lain-lain (nyatakan:   )"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,"-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Disediakan oleh Urus Setia JPAK:"]
[null,null,"CONTOH PENGISIAN"]
[]
[null,"Skop/ Aktiviti/ Butiran Aktiviti",null,null,"Maklumat Kontrak ",null,null,null,null,null,"POPA & Bajet Tahunan",null,null,null,null,null,null,"KPI Penyenggaraan"]
[null,null,null,null,null,null,null,null,"Pihak Yang Berkaitan",null,"Program Operasi dan Penyenggaraan Aset",null,null,"Anggaran Belanjawan Mengurus\nOperasi dan Penyenggaraan Aset",null,null,null,"Operasi Aset",null,null,"Penyenggaraan Pembaikan (PyB)",null,null,null,"Penyenggaraan Pencegahan (PyC)",null,null,"Kajian Kepuasan\n(KK)\n",null,null,null,null,"Pencapaian KPI Penyenggaraan"]
[null,"Skop/ Aktiviti/ Butiran Aktiviti",null,null,"Tarikh Mula","Tarikh Siap","Nilai Kontrak (RM)","No. Kontrak","Pihak Yang Menguruskan","Kontraktor","Rancang (Bil.) \n(a)","Laksana (Bil.)  \n(b) ","% Pencapaian \n(b)/(a) ","Mohon (RM) ","Terima (RM) \n( c) ","Jumlah Belanja (RM) \n(d) M6.","% Perbelanjaan \n(d) / ( c) ","Bil. aktiviti Operasi Aset yang dilaksanakan","Bil. aktiviti Operasi Aset yang dirancang","PI Operasi Aset (OA) (%)","Bil. aduan kerosakan mengikut tempoh respon ASL (a)","Bil. aduan kerosakan ditutup mengikut ASL","Bil. aduan kerosakan keseluruhan","PI Penyenggaraan Pembaikan (PyB) (%)","Bil. PPM yang dilaksanakan","Bil. PPM yang dijadualkan","PI Penyenggaraan Pencegahan (PyC) (%) ","Bil. respoden CSS yang berpuas hati","Bil. keseluruhan responden CSS","Bil. respoden SSS yang berpuas hati","Bil. keseluruhan responden SSS","PI Kajian Kepuasan (KK) (%)","Jumlah markah keseluruhan (%) \nPI (OA + PyB + PyC + KK)"]
[null,"SKOP OPERASI ASET"]
[null,"SKOP : OPERASI ASET","A1- Pengurusan Pengemasan (Housekeeping)","Pengurusan Pengemasan (Housekeeping) dan membersih pejabat","2021-01-01","2025-12-31",50000,80006,"PDRM","Mice Resources",1,1,1,10000,10000,8000,0.8,0,0,0,"TB","TB","TB",0,"TB","TB",0,0,0,0,0,0,0]
[null,"UTILITI"]
[null,"SKOP : OPERASI ASET","A5- Pengurusan Utiliti","Bil Elektrik",null,null,null,null,null,null,1,1,1,100000,80000,65400,0.8175,"TB","TB",0,"TB","TB","TB",0,"TB","TB",0,"TB","TB","TB","TB",0,0]
[null,"SEWAAN BULANAN PREMIS"]
[null,"SKOP : OPERASI ASET","A10- Lain-lain (nyatakan:   )","Sewaan Pejabat","2021-01-01","2025-12-31",48000,80013,"PDRM","-",1,1,1,12000,12000,9000,0.75,"TB","TB",0,"TB","TB","TB",0,"TB","TB",0,"TB","TB","TB","TB",0,0]
[null,"PENYENGGARAAN PEMBAIKAN (PyB)"]
[null,"SKOP : PENYENGARAAN PEMBAIKAN (PyB)","B2- Secara Luar Jangka","Membaiki kebocoran paip di tandas lelaki di blok A","2023-09-03","2023-12-31",5000,80015,"PDRM","Triangle Sdn Bhd",1,1,1,5000,5000,0,0,"TB","TB",0,0,0,0,0,"TB","TB",0,0,0,0,0,0,0]
[null,"PENYENGGARAAN PENCEGAHAN (PyC)"]
[null,"SKOP: PENYENGARAAN PENCEGAHAN (PyC)","C2- Mekanikal","Kerja-kerja menyelenggara penghawa dingin","2023-01-01","2023-12-31",12000,10234,"PDRM","Abc Sdn Bhd",1,1,1,12000,12000,8000,0.66666666666666663,"TB","TB",0,"TB","TB","TB",0,0,0,0,0,0,0,0,0,0]

{"sheet":"F8 5 (NILAI)","index":7,"n_rows":101,"n_cols":28,"rows_kept":101,"cut":false,"hidden":false,"merged":[[98,4,98,6],[98,7,98,10],[19,4,19,10],[1,1,1,12],[2,1,2,12],[3,1,3,12],[11,4,11,6],[11,1,11,2],[11,7,11,10],[98,1,99,2]]}
[]
[null,"JKR.PATA.F8/5"]
[null,"LAPORAN PENILAIAN ASET TAK ALIH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Ruangan ini ialah bagi tujuan LINK EXCEL (JANGAN DELETE)"]
[null,"(Peringkat Premis)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Link Drop Down Skop Penilaian",null,"*Link Drop Down Skop Penilaian"]
[null,null,null,"Bulan :",{"$f":"'MUKA HADAPAN'!$D$5","v":"Sila Pilih"},null,null,null,null,null,"Tahun  :",{"$f":"'MUKA HADAPAN'!$D$6","v":"Sila Kemaskini"},null,null,null,null,null,null,"Sila Pilih Skop",null,"Sila Pilih Skop"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skop: Penilaian Keadaan Aset",null,"Building Condition Assessment (BCA)"]
[null,"Kementerian              :",{"$f":"'MUKA HADAPAN'!$D$7","v":"Sila Pilih"},null,null,null,null,null,"Jabatan/Agensi :     ",{"$f":"'MUKA HADAPAN'!$D$10","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,"Skop: Penilaian Prestasi Aset",null,"Building Performance Assessment (BPA)"]
[null,"Negeri/ Wilayah         :",{"$f":"'MUKA HADAPAN'!$D$8","v":"Sila Pilih"},null,null,null,null,null,"Daerah: ",{"$f":"'MUKA HADAPAN'!$D$9","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,"-",null,"Post Occupancy Evaluation (POE)"]
[null,"Nama Premis             : ",{"$f":"'MUKA HADAPAN'!$D$11","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Facilties Condition Assessment (FCA)"]
[null,"No DPA                     : ",{"$f":"'MUKA HADAPAN'!$D$12","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Laporan Forensik"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lain- Lain "]
[null,"Skop",null,null,"Program Penilaian Aset",null,null,"Anggaran Belanjawan Mengurus (ABM)",null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,"Skop","Butiran Aktiviti","Saiz (keluasan lantai / Panjang laluan / dll)","Rancang (Bil.) \n(a)","Laksana (Bil.)  \n(b) ","% Pencapaian \n(b)/(a) ","Mohon (RM) ","Terima (RM)\n( c) ","Jumlah Belanja (RM)\n(d) ","% Perbelanjaan \n(d) / ( c)  ","Jenis Penilaian","Tahap Penilaian"]
[null,"Sila Pilih Skop","Sila masukkan butiran aktiviti",0,0,0,{"$f":"IFERROR($F14/$E14,0%)","v":0},0,0,0,{"$f":"IFERROR($J14/$I14,0%)","v":0},"Sila Pilih Skop","-"]
[null,"Sila Pilih Skop","Sila masukkan butiran aktiviti",0,0,0,0,0,0,0,0,"Sila Pilih Skop","-"]
[null,"Sila Pilih Skop","Sila masukkan butiran aktiviti",0,0,0,0,0,0,0,0,"Sila Pilih Skop","-"]
[null,"Sila Pilih Skop","Sila masukkan butiran aktiviti",0,0,0,0,0,0,0,0,"Sila Pilih Skop","-"]
[null,"Sila Pilih Skop","Sila masukkan butiran aktiviti",0,0,0,0,0,0,0,0,"Sila Pilih Skop","-"]
[null,"Jumlah",null,null,{"$f":"SUBTOTAL(109,T_F8_5[Rancang (Bil.) \n(a)])","v":0},{"$f":"SUBTOTAL(109,T_F8_5[Laksana (Bil.)  \n(b) ])","v":0},{"$f":"IFERROR(F19/E19,0%)","v":0},{"$f":"SUBTOTAL(109,T_F8_5[Mohon (RM) ])","v":0},{"$f":"SUBTOTAL(109,T_F8_5[Terima (RM)\n( c) ])","v":0},{"$f":"SUBTOTAL(109,T_F8_5[Jumlah Belanja (RM)\n(d) ])","v":0},{"$f":"IFERROR($J19/$I19,0%)","v":0}]
[null,null,null,null,"Data ini dibawa ke JKR.PATA-3B (Penilaian)"]
[]
[null,"Catatan              :"]
[]
[null,"Disediakan Oleh:",null,null,null,null,null,null,null,null,null,null,"Disahkan Oleh :"]
[]
[]
[]
[null,"(cap nama, jawatan)",null,null,null,null,null,null,null,null,null,null,"(cap nama, jawatan)"]
[null,"Tarikh :",null,null,null,null,null,null,null,null,null,null,"Tarikh :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Ruangan ini ialah bagi tujuan LINK EXCEL (JANGAN DELETE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Link Drop Down Skop Penilaian"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Sila Pilih Skop","Building Condition Assessment (BCA)","Building Performance Assessment (BPA)","Post Occupancy Evaluation (POE)","Facilties Condition Assessment (FCA)","Laporan Forensik","Lain- Lain ","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"-","Sila Pilih Tahap:","Sila Pilih Taraf:","TAHAP 3- SANGAT BAIK","-","-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,"RATING A- SANGAT BAIK","5 BINTANG","TAHAP 2- BAIK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,"RATING B- BAIK","4 BINTANG","TAHAP 1- LEMAH"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,"RATING C- SEDERHANA","3 BINTANG","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,"RATING D- KRITIKAL","2 BINTANG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,"RATING E- SANGAT KRITIKAL","1 BINTANG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,"-","-"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Disediakan oleh Urus Setia JPAK:"]
[null,"CONTOH PENGISIAN"]
[]
[null,"Skop",null,null,"Program Penilaian Aset",null,null,"Anggaran Belanjawan Mengurus (ABM)"]
[null,null,null,"Saiz (keluasan lantai / Panjang laluan / dll)","Rancang (Bil.) \n(a)","Laksana (Bil.)  \n(b) ","% Pencapaian \n(b)/(a) ","Mohon (RM) ","Terima (RM)\n( c) ","Jumlah Belanja (RM)\n(d) ","% Perbelanjaan \n(d) / ( c)  ","Jenis Penilaian","Tahap Penilaian"]
[null,"Skop: Penilaian Keadaan Aset","Penilaian Keadaan Aset (BCA) bagi IPD Kluang","2000 M2",1,1,1,0,0,0,0,"Building Condition Assessment (BCA)","RATING E- SANGAT KRITIKAL"]

{"sheet":"F9 2 (PPUN)","index":8,"n_rows":197,"n_cols":26,"rows_kept":197,"cut":false,"hidden":false,"merged":[[28,17,30,18],[2,1,2,21],[3,1,3,21],[24,5,24,13],[1,1,1,21],[11,3,11,4],[11,5,11,7],[11,8,11,9],[11,10,11,13],[11,14,11,16],[11,17,11,19],[11,20,11,21],[4,14,4,15],[11,1,11,2],[194,14,194,16],[194,17,194,19],[194,20,194,21],[194,1,194,2],[194,3,194,4],[194,5,194,7],[194,8,194,9],[194,10,194,13]]}
[]
[]
[null,"LAPORAN PEMULIHAN / PEMULIHARAAN /UBAH SUAI / NAIK TARAF ASET TAK ALIH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Ruangan ini ialah bagi tujuan LINK EXCEL (JANGAN DELETE)"]
[null,"(Peringkat Premis)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Link Drop Down Kaedah Pelupusan ",null,"*Link Drop Down Kaedah Pelupusan "]
[null,null,null,null,null,null,null,null,"Bulan               :",{"$f":"'MUKA HADAPAN'!$D$5","v":"Sila Pilih"},null,null,null,"Tahun:",{"$f":"'MUKA HADAPAN'!$D$6","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,"Sila Pilih Skop",null,"√"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skop: Pemulihan \nAset",null,"-"]
[null,"Kementerian                      :",null,{"$f":"'MUKA HADAPAN'!$D$7","v":"Sila Pilih"},null,null,null,null,null,null,null,null,null,null,null,"Jabatan/Agensi   : ",{"$f":"'MUKA HADAPAN'!$D$10","v":"Sila Kemaskini"},null,null,null,null,null,null,"Skop:Pemuliharaan Aset"]
[null,"Negeri /Wilayah                 :",null,{"$f":"'MUKA HADAPAN'!$D$8","v":"Sila Pilih"},null,null,null,null,null,null,null,null,null,null,null,"Daerah  : ",{"$f":"'MUKA HADAPAN'!$D$9","v":"Sila Kemaskini"},null,null,null,null,null,null,"Skop:Ubah Suai Aset"]
[null,"Nama Premis                     :",null,{"$f":"'MUKA HADAPAN'!$D$11","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Skop:Naik Taraf Aset"]
[null,"No. DPA                             :",null,{"$f":"'MUKA HADAPAN'!$D$12","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[]
[null,"Nama Projek",null,"Maklumat Projek",null,"Bil. Projek",null,null,"Kos Projek Keseluruhan",null,"Peruntukan Tahunan (RM)",null,null,null,"Tempoh Projek Rancang",null,null,"Tempoh Projek Sebenar",null,null,"Kemajuan Projek"]
[null,"Skop","Butiran Projek/ Kerja","Saiz (luas/panjang)","Pihak Pelaksana Projek","Rancang (Bil.) \n(a) M8.","Laksana (Bil.)  \n(b) M8.","% Pencapaian (b)/(a)\nM8.","Rancang (RM)","Sebenar (RM)","Mohon (RM) ","Terima (RM) \n( c)","Jumlah Belanja (RM) \n( d) ","% Perbelanjaan \n(d) / ( c) M8.","Tarikh Mula_R","Tarikh Siap_R","Tarikh Serahan_R","Tarikh Mula_S","Tarikh Siap_S","Tarikh Serahan_S","Ikut Jadual","Lewat"]
[null,"Sila Pilih Skop","Sila masukkan butiran aktiviti/ projek","-","-",0,0,{"$f":"IFERROR($G14/$F14,0%)","v":0},0,0,0,0,0,{"$f":"IFERROR($M14/$L14,0%)","v":0},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","-","-"]
[null,"Sila Pilih Skop","Sila masukkan butiran aktiviti/ projek","-","-",0,0,0,0,0,0,0,0,0,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","-","-"]
[null,"Sila Pilih Skop","Sila masukkan butiran aktiviti/ projek","-","-",0,0,0,0,0,0,0,0,0,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","-","-"]
[null,"Sila Pilih Skop","Sila masukkan butiran aktiviti/ projek","-","-",0,0,0,0,0,0,0,0,0,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","-","-"]
[null,"Sila Pilih Skop","Sila masukkan butiran aktiviti/ projek","-","-",0,0,0,0,0,0,0,0,0,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","-","-"]
[null,"Sila Pilih Skop","Sila masukkan butiran aktiviti/ projek",null,null,0,0,0,0,0,0,0,0,0,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","-","-"]
[null,"Sila Pilih Skop","Sila masukkan butiran aktiviti/ projek",null,null,0,0,0,0,0,0,0,0,0,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","-","-"]
[null,"Sila Pilih Skop","Sila masukkan butiran aktiviti/ projek",null,null,0,0,0,0,0,0,0,0,0,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","-","-"]
[null,"Sila Pilih Skop","Sila masukkan butiran aktiviti/ projek",null,null,0,0,0,0,0,0,0,0,0,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","-","-"]
[null,"Sila Pilih Skop","Sila masukkan butiran aktiviti/ projek",null,null,0,0,0,0,0,0,0,0,0,"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","-","-"]
[null,"Jumlah",null,null,null,{"$f":"SUBTOTAL(109,T_F9_2[Rancang (Bil.) \n(a) M8.])","v":0},{"$f":"SUM(G14:G23)","v":0},{"$f":"IFERROR($F24/$G24,0%)","v":0},{"$f":"SUBTOTAL(109,T_F9_2[Rancang (RM)])","v":0},{"$f":"SUBTOTAL(109,T_F9_2[Sebenar (RM)])","v":0},{"$f":"SUBTOTAL(109,T_F9_2[Mohon (RM) ])","v":0},{"$f":"SUBTOTAL(109,T_F9_2[Terima (RM) \n( c)])","v":0},{"$f":"SUBTOTAL(109,T_F9_2[Jumlah Belanja (RM) \n( d) ])","v":0},{"$f":"IFERROR($M24/$L24,0%)","v":0},null,null,null,null,null,null,{"$f":"COUNTIF(U14:U23, \"√\")","v":0},{"$f":"COUNTIF(V14:V23, \"√\")","v":0}]
[null,null,null,null,null,"Data ini dibawa ke JKR.PATA-3B (Pemulihan/ Ubah Suai/ Naik Taraf)"]
[null,null,"Catatan      :"]
[]
[null,null,"Disediakan Oleh:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disahkan Oleh :"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(POF)"]
[null,null,"(cap nama & jawatan)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(cap nama, jawatan)"]
[]
[]
[null,null,"Tarikh : ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tarikh :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Disediakan oleh Urus Setia JPAK:"]
[null,null,"CONTOH PENGISIAN"]
[]
[null,"Nama Projek",null,"Maklumat Projek",null,"Bil. Projek",null,null,"Kos Projek Keseluruhan",null,"Peruntukan Tahunan (RM)",null,null,null,"Tempoh Projek Rancang",null,null,"Tempoh Projek Sebenar",null,null,"Kemajuan Projek"]
[null,null,null,"Saiz (luas/panjang)","Pihak Pelaksana Projek","Rancang (Bil.) \n(a) M8.","Laksana (Bil.)  \n(b) M8.","% Pencapaian (b)/(a)\nM8.","Rancang (RM)","Sebenar (RM)","Mohon (RM) ","Terima (RM) \n( c)","Jumlah Belanja (RM) \n( d) ","% Perbelanjaan \n(d) / ( c) M8.","Tarikh Mula_R","Tarikh Siap_R","Tarikh Serahan_R","Tarikh Mula_S","Tarikh Siap_S","Tarikh Serahan_S","Ikut Jadual","Lewat"]
[null,"Skop:Ubah Suai Aset","Kerja-Kerja Mengubahsuai Bilik Stor kepada Bilik Mesyuarat","200 m²","PDRM",1,1,1,250000,200000,250000,200000,75000,0.375,"2023-04-04","2023-11-30","TBA","2023-04-04","2023-11-30","TBA","-","-"]

{"sheet":"F10 5(LUPUS) ","index":9,"n_rows":111,"n_cols":27,"rows_kept":111,"cut":false,"hidden":false,"merged":[[1,1,1,21],[2,1,2,21],[3,1,3,21],[9,14,10,20],[11,7,12,9],[11,1,12,3],[23,20,25,21],[19,7,19,13],[19,14,19,21],[15,24,15,26],[11,10,12,13],[11,14,11,20],[12,14,12,16],[12,17,12,20],[107,1,108,3],[107,7,108,9],[107,10,108,13],[107,14,107,20],[108,14,108,16],[108,17,108,20]]}
[]
[null,"JKR.PATA.F10/5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Ruangan ini ialah bagi tujuan LINK EXCEL (JANGAN DELETE)"]
[null,"LAPORAN PELUPUSAN ASET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Link Drop Down Struktur Binaan/\nKomponen ",null,"*Link Drop Down Kaedah Pelupusan "]
[null,"(Peringkat Premis)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sila Pilih",null,"√"]
[null,null,null,null,null,null,"Bulan     :",{"$f":"'MUKA HADAPAN'!$D$5","v":"Sila Pilih"},null,null,null,"Tahun:",{"$f":"'MUKA HADAPAN'!$D$6","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,null,null,null,"Struktur Binaan",null,"-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Komponen "]
[null,"Kementerian             :",null,{"$f":"'MUKA HADAPAN'!$D$7","v":"Sila Pilih"},null,null,null,null,null,null,null,null,null,"Jabatan/ Agensi       : ",null,null,{"$f":"'MUKA HADAPAN'!$D$10","v":"Sila Kemaskini"},null,null,null,null,null,null,null,"-"]
[null,"Negeri /Wilayah        :",null,{"$f":"'MUKA HADAPAN'!$D$8","v":"Sila Pilih"},null,null,null,null,null,null,null,null,null,"Daerah                     : ",null,null,{"$f":"'MUKA HADAPAN'!$D$9","v":"Sila Kemaskini"}]
[null,"Nama Premis            : ",null,{"$f":"'MUKA HADAPAN'!$D$11","v":"Sila Kemaskini"}]
[null,"No. DPA                   : ",null,{"$f":"'MUKA HADAPAN'!$D$12","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,null,null,"Dari JKR.PATA.F10/2 & JKR.PATA.F10/4"]
[]
[null,"Struktur Binaan /\nKomponen & Kod DAK",null,null,null,null,null,"Program Pelupusan Aset",null,null,"Peruntukan Belanja Mengurus",null,null,null,"Kaedah Pelupusan "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Struktur Binaan (Bil.)",null,null,"Komponen (Bil.)"]
[null,"Struktur Binaan /\nKomponen"," Kod DAK","Butiran Pelupusan","Saiz/\nKapasiti/\nKuantiti","Kos Perolehan Aset (RM)","Nilai Semasa Aset (RM)","Rancang (Bil.)\n(a) ","Laksana (Bil.)  \n(b) ","% Pencapaian\n(b)/( a) ","Mohon (RM) ","Terima (RM) \n( c) ","Jumlah Belanja (RM) \n( d) ","% Perbelanjaan \n(d) / ( c) ","Roboh/ Musnah ","Pelepasan Hak","Pindah Milik","Musnah","Jualan"," Hadiah","Pindahan","Hasil Pelupusan \n(RM)"]
[null,"Sila Pilih","Sila masukkan Kod DAK","Sila masukkan butiran aktiviti","-",0,0,0,0,{"$f":"IFERROR($I15/$H15,0%)","v":0},0,0,0,{"$f":"IFERROR($M15/$L15,0%)","v":0},"-","-","-","-","-","-","-",0]
[null,"Sila Pilih","Sila masukkan Kod DAK","Sila masukkan butiran aktiviti","-",0,0,0,0,0,0,0,0,0,"-","-","-","-","-","-","-",0]
[null,"Sila Pilih","Sila masukkan Kod DAK","Sila masukkan butiran aktiviti","-",0,0,0,0,0,0,0,0,0,"-","-","-","-","-","-","-",0]
[null,"Sila Pilih","Sila masukkan Kod DAK","Sila masukkan butiran aktiviti","-",0,0,0,0,0,0,0,0,0,"-","-","-","-","-","-","-",0]
[null,"Jumlah",null,null,null,{"$f":"SUBTOTAL(109,T_F10_5[Kos Perolehan Aset (RM)])","v":0},{"$f":"SUBTOTAL(109,T_F10_5[Nilai Semasa Aset (RM)])","v":0},{"$f":"SUBTOTAL(109,T_F10_5[Rancang (Bil.)\n(a) ])","v":0},{"$f":"SUBTOTAL(109,T_F10_5[Laksana (Bil.)  \n(b) ])","v":0},{"$f":"IFERROR($I19/$H19,0%)","v":0},{"$f":"SUBTOTAL(109,T_F10_5[Mohon (RM) ])","v":0},{"$f":"SUBTOTAL(109,T_F10_5[Terima (RM) \n( c) ])","v":0},{"$f":"SUBTOTAL(109,T_F10_5[Jumlah Belanja (RM) \n( d) ])","v":0},{"$f":"IFERROR($M19/$L19,0%)","v":0},{"$f":"COUNTIF(O15:O18, \"√\")","v":0},{"$f":"COUNTIF(P15:P18, \"√\")","v":0},0,0,0,0,0,{"$f":"SUBTOTAL(109,T_F10_5[Hasil Pelupusan \n(RM)])","v":0}]
[null,null,null,null,null,null,"JKR.PATA-3C","Data ini dibawa ke JKR.PATA-3B (Pelupusan)",null,null,null,null,null,null,"Data ini dibawa ke JKR.PATA-3C (Pelupusan)"]
[null,"Catatan     :"]
[]
[null,"Disediakan Oleh:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disahkan Oleh :"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(POF)"]
[null,"(cap nama, jawatan)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(cap nama, jawatan)"]
[null,"Tarikh :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tarikh :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Disediakan oleh Urus Setia JPAK:"]
[null,null,null,"CONTOH PENGISIAN"]
[]
[null,"Struktur Binaan /\nKomponen & Kod DAK",null,null,null,null,null,"Program Pelupusan Aset",null,null,"Peruntukan Belanja Mengurus",null,null,null,"Kaedah Pelupusan "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Struktur Binaan (Bil.)",null,null,"Komponen (Bil.)"]
[null,null,null,null,"Saiz/\nKapasiti/\nKuantiti","Kos Perolehan Aset (RM)","Nilai Semasa Aset (RM)","Rancang (Bil.)\n(a) ","Laksana (Bil.)  \n(b) ","% Pencapaian\n(b)/( a) ","Mohon (RM) ","Terima (RM) \n( c) ","Jumlah Belanja (RM) \n( d) ","% Perbelanjaan \n(d) / ( c) ","Roboh/ Musnah ","Pelepasan Hak","Pindah Milik","Musnah","Jualan"," Hadiah","Pindahan","Hasil Pelupusan \n(RM)"]
[null,"Komponen ","M1815.00103 (A.01.001)","Pelupusan Penyaman Udara (INDOOR WALLMOUNTED FUJITSU LP456)","2HP",1800,500,1,1,1,0,0,0,0,"-","-","-","-","√","-","-",500]

{"sheet":"F11 5 (HAPUSKIRA)","index":10,"n_rows":139,"n_cols":14,"rows_kept":139,"cut":false,"hidden":false,"merged":[[1,1,1,9],[11,6,11,9],[12,1,12,2],[136,1,136,2],[22,9,24,9],[2,1,2,9],[3,1,3,9],[18,8,18,9]]}
[]
[null,"JKR.PATA.F11/5"]
[null,"LAPORAN KEHILANGAN DAN HAPUS KIRA ASET TAK ALIH"]
[null,"(Peringkat Premis)"]
[]
[null,null,null,"Bulan   :",{"$f":"'MUKA HADAPAN'!$D$5","v":"Sila Pilih"},null,null,"Tahun  :",{"$f":"'MUKA HADAPAN'!$D$6","v":"Sila Kemaskini"}]
[null,null,null,null,null,null,null,null,null,null,null,"*Ruangan ini ialah bagi tujuan LINK EXCEL (JANGAN DELETE)"]
[null,"Kementerian       :",{"$f":"'MUKA HADAPAN'!$D$7","v":"Sila Pilih"},null,null,null,"Jabatan/Agensi :     ",{"$f":"'MUKA HADAPAN'!$D$10","v":"Sila Kemaskini"},null,null,null,"*Link Drop Down Tatatertib Dikenakan",null,"*Link Drop Down Struktur Binaan/\nKomponen Yang Hilang"]
[null,"Negeri /Wilayah  :",{"$f":"'MUKA HADAPAN'!$D$8","v":"Sila Pilih"},null,null,null,"Daerah             : ",{"$f":"'MUKA HADAPAN'!$D$9","v":"Sila Kemaskini"},null,null,null,"Sila Pilih",null,"Sila Pilih"]
[null,"Nama Premis     : ",{"$f":"'MUKA HADAPAN'!$D$11","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,"Ada",null,"Struktur Binaan"]
[null,"No. DPA            : ",{"$f":"'MUKA HADAPAN'!$D$12","v":"Sila Kemaskini"},null,null,null,null,null,null,null,null,"Tiada",null,"Komponen "]
[null,null,null,null,null,null,"Dari JKR.PATA.F11/3 LAPORAN AKHIR KEHILANGAN ASET  & JKR.PATA.F11/4 SIJIL HAPUS KIRA ASET",null,null,null,null,"-",null,"-"]
[null,"Struktur Binaan/\nKomponen Yang Hilang"]
[null,"Struktur Binaan/\nKomponen Yang Hilang","Butiran","Kod DAK","Saiz/\nKapasiti","Bilangan\n_K&H","Kos Perolehan Aset\n (RM)","Nilai Semasa Aset (RM)","Tindakan Tatatertib Dikenakan\n(Ada / Tiada)","Bilangan\n_Tatatertib"]
[null,"Komponen ","Sila masukkan butiran ","Sila masukkan Kod DAK","-",0,0,0,"Sila Pilih",0]
[null,"Struktur Binaan","Sila masukkan butiran ","Sila masukkan Kod DAK","-",0,0,0,"Sila Pilih",0]
[null,"Sila Pilih","Sila masukkan butiran ","Sila masukkan Kod DAK","-",0,0,0,"Sila Pilih",0]
[null,"Jumlah",null,null,null,{"$f":"SUBTOTAL(109,T_F11_5[Bilangan\n_K&H])","v":0},{"$f":"SUBTOTAL(109,T_F11_5[Kos Perolehan Aset\n (RM)])","v":0},{"$f":"SUBTOTAL(109,T_F11_5[Nilai Semasa Aset (RM)])","v":0},null,{"$f":"SUBTOTAL(109,T_F11_5[Bilangan\n_Tatatertib])","v":0}]
[null,null,null,null,null,"JKR.PATA-3C (Hapus Kira)",null,"JKR.PATA-3C (Hapus Kira)"]
[null,"Catatan          :"]
[]
[null,"Disediakan Oleh:",null,null,null,null,null,null,null,"Disahkan Oleh :"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"(POF)"]
[null,"(cap nama, jawatan)",null,null,null,null,null,null,null,"(cap nama, jawatan)"]
[]
[]
[null,"Tarikh :",null,null,null,null,null,null,null,"Tarikh :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Disediakan oleh Urus Setia JPAK:"]
[null,null,"CONTOH PENGISIAN"]
[null,"Struktur Binaan/\nKomponen Yang Hilang",null,"Kod DAK","Saiz/\nKapasiti","Bilangan\n","Kos Perolehan Aset\n (RM)","Nilai Semasa Aset (RM)","Tindakan Tatatertib Dikenakan\n(Ada / Tiada)","Bilangan\n"]
[null,"Komponen ","Penyaman Udara- Outdoor Unit\n(Hilang  disebabkan Kes Kecurian)","M1815.00104 (A.02.001)","3HP",1,2500,0,"Tiada",0]
[null,"Struktur Binaan","Rumah Sampah\n(Hilang disebabkan Kebakaran)","A01R001","10 M2",1,10000,0,"Tiada",0]

{"sheet":"PATA 3C (Premis)","index":11,"n_rows":111,"n_cols":24,"rows_kept":111,"cut":false,"hidden":false,"merged":[[1,0,1,23],[2,0,2,23],[3,0,3,23],[11,22,12,23],[11,19,11,21],[11,4,12,4],[12,19,12,21],[10,3,10,8],[11,2,12,2],[11,3,12,3],[11,1,12,1],[10,22,10,23],[10,19,10,21],[11,16,12,18],[11,14,12,15],[11,10,12,13],[106,1,107,1],[106,2,107,2],[106,3,107,3],[106,4,107,4],[106,5,107,9],[106,22,107,23],[107,19,107,21],[106,10,107,13],[11,5,12,9],[106,14,107,15],[106,16,107,18],[106,19,106,21]]}
[]
["JKR.PATA-3C"]
["LAPORAN KEDUDUKAN, KOS DAN NILAIAN ASET TAK ALIH"]
["(Peringkat Premis)"]
[null,null,null,null,null,null,"Bulan   :",null,{"$f":"'F10 5(LUPUS) '!H5","v":"Sila Pilih"},null,null,null,null,null,"Tahun   :",{"$f":"'F10 5(LUPUS) '!M5","v":"Sila Kemaskini"}]
[]
[null,"Kementerian                              :",{"$f":"'MUKA HADAPAN'!$D$7","v":"Sila Pilih"},null,null,null,null,null,null,null,null,null,null,null,null,"Jabatan / Agensi :",null,{"$f":"'MUKA HADAPAN'!$D$10","v":"Sila Kemaskini"}]
[null,"Negeri/ Wilayah                         :",{"$f":"'MUKA HADAPAN'!$D$8","v":"Sila Pilih"},null,null,null,null,null,null,null,null,null,null,null,null,"Daerah                :",null,{"$f":"'MUKA HADAPAN'!$D$9","v":"Sila Kemaskini"}]
[null,"Nama Premis                             :",{"$f":"'MUKA HADAPAN'!$D$11","v":"Sila Kemaskini"}]
[null,"No. DPA                                    :",{"$f":"'MUKA HADAPAN'!$D$12","v":"Sila Kemaskini"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dari JKR.PATA.F10/5",null,null,"Dari JKR.PATA.F11/5"]
[null,null,null,null,"Premis Aset","10. Kategori Aset",null,null,null,null,"11. Kos Perolehan Aset",null,null,null,"12. Kos Operasi Aset",null,"13. Nilaian Aset",null,null,"14. Pelupusan Aset",null,null,"15. Kehilangan dan Hapus Kira Aset"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Struktur Binaan/ Komponen"]
["Bil\nM3C.","Premis \nM3C.","No. DPA M3C.","Jenis pemilikan M3C.","Jumlah Premis Aset\n= (a)+(b)+(c) +(d)+ (e) M3C.","Bangunan (Bil.) (a) \nM10.","Jalan (Bil.) (b) \nM10.","Pembetungan (Bil.) (c) \nM10.","Air (Bil.) (d) \nM10.","Lain-lain : …….... (nyatakan) (e) \nM10.","Kos Perolehan Tanah (RM) \nM11.","Kos Siap Bina Asal  (RM) (a) \nM11.","Kos Tambahan [PPUN]* (RM) (b) \nM11.","Kos Keseluruhan Aset (RM)\n= (a) + (b) M11.","Jumlah Kos Operasi Bagi Tahun Sebelum (RM) M12.","Jumlah Kos Operasi Bagi Tahun Semasa (RM)\n[Jumlah Belanja, PATA 3B (i), (ii), (iii), (iv), (v)] M12.","Nilaian Semasa Tanah (RM) (a) \nM13.","Nilaian Semasa Binaan (RM) (b) \nM13.","Jumlah Nilai Semasa (RM)\n= (a) + (b) M13.","Bilangan M14.","Nilai Semasa Aset  (RM) M14.","Hasil Pelupusan (RM) M14.","Bilangan M15.","Nilai Semasa Aset (RM) M15."]
[null,{"$f":"Table3A_M_ST[Premis]","v":"Sila Kemaskini"},{"$f":"$C$10","v":"Sila Kemaskini"},{"$f":"Table3B_M_ST[Jenis pemilikan aset M4.]","v":"-"},{"$f":"Table3C_M_ST[[#This Row],[Bangunan (Bil.) (a) \nM10.]]+Table3C_M_ST[[#This Row],[Jalan (Bil.) (b) \nM10.]]+Table3C_M_ST[[#This Row],[Pembetungan (Bil.) (c) \nM10.]]+Table3C_M_ST[[#This Row],[Air (Bil.) (d) \nM10.]]+Table3C_M_ST[[#This Row],[Lain-lain : …….... (nyatakan) (e) \nM10.]]","v":0},{"$f":"Table3A_M_ST[Bilangan Premis Aset]","v":0},0,0,0,0,0,0,{"$f":"TableL3C[[#Totals],[KOS TAHUNAN PPUN]]","v":0},{"$f":"Table3C_M_ST[[#This Row],[Kos Tambahan '[PPUN']* (RM) (b) \nM11.]]+Table3C_M_ST[[#This Row],[Kos Siap Bina Asal  (RM) (a) \nM11.]]","v":0},0,{"$f":"Table3B_M_ST[[#Totals],[Jumlah Belanja (RM) \n(d) M5.]]+Table3B_M_ST[[#Totals],[Jumlah Belanja (RM) \n(d) M6.]]+Table3B_M_ST[[#Totals],[Jumlah Belanja (RM)\n(d) M7.]]+Table3B_M_ST[[#Totals],[Jumlah Belanja (RM) \n( d) M8.]]+Table3B_M_ST[[#Totals],[Jumlah Belanja (RM) \n( d) M9.]]","v":0},0,0,{"$f":"Table3C_M_ST[[#This Row],[Nilaian Semasa Tanah (RM) (a) \nM13.]]+Table3C_M_ST[[#This Row],[Nilaian Semasa Binaan (RM) (b) \nM13.]]","v":0},{"$f":"T_F10_5[[#Totals],[Roboh/ Musnah ]]+T_F10_5[[#Totals],[Pelepasan Hak]]+T_F10_5[[#Totals],[Pindah Milik]]+T_F10_5[[#Totals],[Musnah]]+T_F10_5[[#Totals],[Jualan]]+T_F10_5[[#Totals],[ Hadiah]]+T_F10_5[[#Totals],[Pindahan]]","v":0},{"$f":"T_F10_5[[#Totals],[Nilai Semasa Aset (RM)]]","v":0},{"$f":"T_F10_5[[#Totals],[Hasil Pelupusan \n(RM)]]","v":0},{"$f":"T_F11_5[[#Totals],[Bilangan\n_K&H]]","v":0},{"$f":"T_F11_5[[#Totals],[Nilai Semasa Aset (RM)]]","v":0}]
["1",{"$f":"Table3C_M_ST[Premis \nM3C.]","v":"Sila Kemaskini"},{"$f":"Table3C_M_ST[No. DPA M3C.]","v":"Sila Kemaskini"},{"$f":"Table3C_M_ST[Jenis pemilikan M3C.]","v":"-"},{"$f":"SUBTOTAL(109,Table3C_M_ST[Jumlah Premis Aset\n= (a)+(b)+(c) +(d)+ (e) M3C.])","v":0},{"$f":"SUBTOTAL(109,Table3C_M_ST[Bangunan (Bil.) (a) \nM10.])","v":0},{"$f":"SUBTOTAL(109,Table3C_M_ST[Jalan (Bil.) (b) \nM10.])","v":0},{"$f":"SUBTOTAL(109,Table3C_M_ST[Pembetungan (Bil.) (c) \nM10.])","v":0},{"$f":"SUBTOTAL(109,Table3C_M_ST[Air (Bil.) (d) \nM10.])","v":0},{"$f":"SUBTOTAL(109,Table3C_M_ST[Lain-lain : …….... (nyatakan) (e) \nM10.])","v":0},{"$f":"SUBTOTAL(109,Table3C_M_ST[Kos Perolehan Tanah (RM) \nM11.])","v":0},{"$f":"SUBTOTAL(109,Table3C_M_ST[Kos Siap Bina Asal  (RM) (a) \nM11.])","v":0},{"$f":"SUBTOTAL(109,Table3C_M_ST[Kos Tambahan '[PPUN']* (RM) (b) \nM11.])","v":0},{"$f":"SUBTOTAL(109,Table3C_M_ST[Kos Keseluruhan Aset (RM)\n= (a) + (b) M11.])","v":0},{"$f":"SUBTOTAL(109,Table3C_M_ST[Jumlah Kos Operasi Bagi Tahun Sebelum (RM) M12.])","v":0},{"$f":"SUBTOTAL(109,Table3C_M_ST[Jumlah Kos Operasi Bagi Tahun Semasa (RM)\n'[Jumlah Belanja, PATA 3B (i), (ii), (iii), (iv), (v)'] M12.])","v":0},{"$f":"SUBTOTAL(105,Table3C_M_ST[Nilaian Semasa Tanah (RM) (a) \nM13.])","v":0},{"$f":"SUBTOTAL(109,Table3C_M_ST[Nilaian Semasa Binaan (RM) (b) \nM13.])","v":0},{"$f":"SUBTOTAL(109,Table3C_M_ST[Jumlah Nilai Semasa (RM)\n= (a) + (b) M13.])","v":0},{"$f":"SUBTOTAL(109,Table3C_M_ST[Bilangan M14.])","v":0},{"$f":"SUBTOTAL(109,Table3C_M_ST[Nilai Semasa Aset  (RM) M14.])","v":0},{"$f":"SUBTOTAL(109,Table3C_M_ST[Hasil Pelupusan (RM) M14.])","v":0},{"$f":"SUBTOTAL(109,Table3C_M_ST[Bilangan M15.])","v":0},{"$f":"SUBTOTAL(109,Table3C_M_ST[Nilai Semasa Aset (RM) M15.])","v":0}]
[]
[null,"  Petunjuk: *Kos Tambahan [PPUN] Bagi Tahun-Tahun Sebelum Secara Kumulatif"]
[]
[null,"   Disediakan Oleh :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Disahkan  Oleh :"]
[]
[]
[]
[null,"  (cap nama & jawatan)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(cap nama & jawatan)"]
[null,"  Tarikh :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tarikh :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Disediakan oleh Urus Setia JPAK:"]
[null,"CONTOH PENGISIAN"]
[]
[null,null,null,null,"Premis Aset","10. Kategori Aset",null,null,null,null,"11. Kos Perolehan Aset",null,null,null,"12. Kos Operasi Aset",null,"13. Nilaian Aset",null,null,"14. Pelupusan Aset",null,null,"15. Kehilangan dan Hapus Kira Aset"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Struktur Binaan/ Komponen"]
["Bil","Premis \n","No. DPA ","Jenis pemilikan ","Jumlah Premis Aset\n= (a)+(b)+(c) +(d)+ (e) ","Bangunan (Bil.) (a) \n","Jalan (Bil.) (b) \n","Pembetungan (Bil.) (c) \n","Air (Bil.) (d) \n","Lain-lain : …….... (nyatakan) (e) \n","Kos Perolehan Tanah (RM) \n","Kos Siap Bina Asal  (RM) (a) \n","Kos Tambahan [PPUN]* (RM) (b) \n","Kos Keseluruhan Aset (RM)\n= (a) + (b) ","Jumlah Kos Operasi Bagi Tahun Sebelum (RM) ","Jumlah Kos Operasi Bagi Tahun Semasa (RM)\n[Jumlah Belanja, PATA 3B (i), (ii), (iii), (iv), (v)] M12.","Nilaian Semasa Tanah (RM) (a) \n","Nilaian Semasa Binaan (RM) (b) \n","Jumlah Nilai Semasa (RM)\n= (a) + (b) ","Bilangan","Nilai Semasa Aset  (RM) ","Hasil Pelupusan (RM) ","Bilangan ","Nilai Semasa Aset (RM)"]
[null,"IBU PEJABAT POLIS DAERAH KLUANG JOHOR","1146110MYS.010340.BS0003","M",1,1,0,0,0,0,10000,700000,400000,1100000,1900000,1608550,800000,600000,1400000,2,500,500,2,0]
["1","IBU PEJABAT POLIS DAERAH KLUANG JOHOR",null,"M",1,1,0,0,0,0,10000,700000,400000,1100000,1900000,1608550,800000,600000,1400000,2,500,500,2,0]

{"sheet":"LAMPIRAN 3C","index":12,"n_rows":25,"n_cols":17,"rows_kept":25,"cut":false,"hidden":false,"merged":[[6,1,7,1],[6,2,6,4],[6,5,6,6],[6,10,6,13],[6,14,6,16],[1,8,1,9],[1,15,1,16],[7,2,7,4],[5,10,5,13],[5,14,5,16],[7,14,7,15],[7,10,7,12],[5,2,5,4],[7,5,7,6],[5,5,5,6],[7,7,7,8],[5,7,5,9],[6,7,6,9]]}
[]
[null,null,"REKOD TAHUNAN ASET ",null,null,null,null,null,"LAMPIRAN 3C",null,null,null,null,null,null,"LAMPIRAN 3C"]
[]
[null,null,"Ruangan ini perlu dikemaskini pada setiap Sukuan 1 ,Tahun Berikutnya"]
[]
[null,null,"JKR.PATA.3C Kos Tambahan [PPUN]",null,null,"JKR.PATA.3C Kos Operasi Aset",null,"JKR.PATA.3C Nilaian Aset",null,null,"JKR.PATA.3C Pelupusan Aset",null,null,null,"JKR.PATA.3C Kehilangan dan Hapus Kira Aset"]
[null,"Penerangan","Jumlah Kos Tambahan [PPUN] Bagi Tahun-Tahun Sebelum (RM)",null,null,"Jumlah Kos Operasi Bagi Tahun-Tahun Sebelum (RM)",null,"Nilaian Aset Bagi Tahun-Tahun Sebelum (RM)",null,null,"Rekod Pelupusan Aset Bagi Tahun-Tahun Sebelum",null,null,null,"Rekod Kehilangan dan Hapus Kira Aset Bagi Tahun-Tahun Sebelum"]
[null,null,"*Sila Rujuk Laporan JKR.PATA.F9/2 Sehingga Sukuan 4",null,null,"*Sila Rujuk Laporan JKR.PATA.3C Sehingga Sukuan 4",null,"*Sila Rujuk Nilai Pasaran Semasa daripada Laporan JPPH/ Setaraf ",null,"No Rujukan Laporan/ Surat daripada JPPH atau Setaraf","*Sila Rujuk Laporan JKR.PATA.3C Sehingga Sukuan 4",null,null,"No Rujukan Laporan Verifikasi & Pelupusan JKR.PATA.F10/2","*Sila Rujuk Laporan JKR.PATA.F11/5 Sehingga Sukuan 4",null,"No Rujukan Laporan Akhir Kehilangan dan Hapus Kira Aset JKR.PATA.F11/3"]
[null,"TAHUN","BILANGAN PROJEK PEMULIHAN/ UBAH SUAI / NAIK TARAF","KOS TAHUNAN PPUN","RUJUKAN (Sekiranya Ada)","KOS TAHUNAN KOS OPERASI ASET","RUJUKAN (Sekiranya Ada)2","NILAI SEMASA TANAH","NILAI SEMASA BINAAN","RUJUKAN (Sekiranya Ada)3","BILANGAN","NILAI SEMASA ASET  (RM)\n(sebelum dilupuskan)","HASIL PELUPUSAN (RM)","RUJUKAN (Sekiranya Ada) 4","BILANGAN 2","NILAI SEMASA ASET (RM)","RUJUKAN (Sekiranya Ada) 5"]
[null,2017,0,0,null,0,null,0,0,null,0,0,0,null,0,0]
[null,2018,0,0,null,0,null,0,0,null,0,0,0,null,0,0]
[null,2019,0,0,null,0,null,0,0,null,0,0,0,null,0,0]
[null,2020,0,0,null,0,null,0,0,"                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     ",0,0,0,null,0,0]
[null,2021,0,0,null,0,null,0,0,null,0,0,0,null,0,0]
[null,2022,0,0,null,0,null,0,0,null,0,0,0,null,0,0]
[null,2023,0,0,null,0,null,0,0,null,0,0,0,null,0,0]
[null,2024,0,0,null,0,null,0,0,null,0,0,0,null,0,0]
[null,2025,0,0,null,0,null,0,0,null,0,0,0,null,0,0]
[null,2026,0,0,null,0,null,0,0,null,0,0,0,null,0,0]
[null,2027,0,0,null,0,null,0,0,null,0,0,0,null,0,0]
[null,2028,0,0,null,0,null,0,0,null,0,0,0,null,0,0]
[null,2029,0,0,null,0,null,0,0,null,0,0,0,null,0,0]
[]
[]
[null,"Total",null,{"$f":"SUBTOTAL(109,TableL3C[KOS TAHUNAN PPUN])","v":0},null,{"$f":"SUBTOTAL(109,TableL3C[KOS TAHUNAN KOS OPERASI ASET])","v":0},null,null,null,null,{"$f":"SUBTOTAL(109,TableL3C[BILANGAN])","v":0},{"$f":"SUBTOTAL(109,TableL3C[NILAI SEMASA ASET  (RM)\n(sebelum dilupuskan)])","v":0},{"$f":"SUBTOTAL(109,TableL3C[HASIL PELUPUSAN (RM)])","v":0},null,{"$f":"SUBTOTAL(109,TableL3C[BILANGAN 2])","v":0},{"$f":"SUBTOTAL(109,TableL3C[NILAI SEMASA ASET (RM)])","v":0}]